hi i want to make formula to search from other sheet named Expenditure but it giving random dates in cell C14 and C15, and it is not giving loan amount in D14 and D15.
pls help
Regds
Waseem
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Search Formula from other sheets
0
Answers
0
Selected Answer
Please try this formual in D14. Enter as array formula and copy down.
=IFERROR(INDEX(Loan_Staff,SMALL(IF((Particular=$E$10)*(Loan_Staff>0),ROW(Date)-ROW(INDEX(Date,1,1))+1),ROW()-13)),"")Discussion
its working good, but i used this formula =IFERROR(AGGREGATE(15,6,Date/((Particular=$E$10)*(Loan_Staff<>"")),ROW()-13),"") in C14 to get the date, but it is giving wrong dates i mean it giving January 1, first and January 24, later while it should be January 24 first and then January 1 later. pls check it
waseem (rep: 4) Jan 31, '19 at 10:58 am
Sorry for the delay, Wasseem. I'm having a bit of a holiday. You can invert the sequence by using AGGREGATE(14... instead of (15...
Variatus (rep: 4889) Feb 4, '19 at 9:27 pm