vlookup and IF function

W

Wanna Learn

Hi this is the formula that I am using for a lookup.
=IF(ISNA(VLOOKUP(H7,'2006 Discount
'!$E$2:$Q$374,7,FALSE)),"",VLOOKUP(H7,'2006 Discount '!$E$2:$Q$374,7,FALSE))
and this works fine, however, if the answer is not found here I want it to
go to another sheet and find it. Is that possible? thanks
 
D

Dave F

Yeah, it's possible. I'm assuming that if the value is not found, by "go to
another sheet" you mean perform a VLOOKUP on a different sheet.

Your formula would look something like this:

=IF(ISNA(VLOOKUP([criteria for first VLOOKUP]),VLOOKUP([do VLOOKUP in other
sheet]),VLOOKUP([original VLOOKUP criteria]))

In plain English, this is saying "IF VLOOKUP returns N/A, THEN do this
alternative VLOOKUP, ELSE do the original VLOOKUP."

You're just replacing the "" in your original formula with the alternative
VLOOKUP.

Dave

It would be something like
 
W

Wanna Learn

Dave F
Thank you so much ,the "plain english" explanation really helped me to
understand the solution. Great Job. Have a nice day

Dave F said:
Yeah, it's possible. I'm assuming that if the value is not found, by "go to
another sheet" you mean perform a VLOOKUP on a different sheet.

Your formula would look something like this:

=IF(ISNA(VLOOKUP([criteria for first VLOOKUP]),VLOOKUP([do VLOOKUP in other
sheet]),VLOOKUP([original VLOOKUP criteria]))

In plain English, this is saying "IF VLOOKUP returns N/A, THEN do this
alternative VLOOKUP, ELSE do the original VLOOKUP."

You're just replacing the "" in your original formula with the alternative
VLOOKUP.

Dave

It would be something like
--
Brevity is the soul of wit.


Wanna Learn said:
Hi this is the formula that I am using for a lookup.
=IF(ISNA(VLOOKUP(H7,'2006 Discount
'!$E$2:$Q$374,7,FALSE)),"",VLOOKUP(H7,'2006 Discount '!$E$2:$Q$374,7,FALSE))
and this works fine, however, if the answer is not found here I want it to
go to another sheet and find it. Is that possible? thanks
Click to expand...
Click to expand...
 
Top