Dear All,
Pls advise how to use vlookup with "if" function. (Vlookup with 2 conditions is not working)
Pls find attached file.
Regards,
Sun
Dear All,
Pls advise how to use vlookup with "if" function. (Vlookup with 2 conditions is not working)
Pls find attached file.
Regards,
Sun
Last edited by Dr.SUN; 03-25-2010 at 03:26 AM. Reason: Forget to attach file.....
with such a little data it's hard to give anything reasonable.. But I'll try:
=IF( condition, VLOOKUP FUNCTION, else)
sorry now i have attached file zbor..................plz give me solution
Dr. Sun,
there is still rather little information about the nature of your lookup.
Assuming that you want to return the name for the values in columns H and I, try this in J2 and copy down
=IFERROR(INDEX(B:B,MATCH(H2&I2,INDEX(C:C&D:D,0),0)),"no match")
The first data pair will not find a match. There is no name with Age = x and Scholarship = 1000. Copied down, the formula will find the name b in row 3 and the name c in row 4
dear teylyn first u see my attached file and confirm.
Regards,
SUN
SUN, I created the formula in your file attachment. You can copy it and paste it into cell J2, then copy down.
Should the formula not do what you require, please be more specific with your requirements. You still have not specified what you want the lookup to return.
x 1000
y 1000
z 2500
Scholarship amount is not displaying...............
U c Ihv used 2 conditions in col d. results are not as expected.
Sun, please use English, not chat talk.
Tell me:
- What do you want to return?
- Where? in which cells?
- Why? what are the conditions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks