Search Formula from other sheets

0

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

Answer
Discuss

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)),"")
Discuss

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: 2803) Feb 4, '19 at 9:27 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login