vlookup and IF function
 

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

vlookup and IF function
 

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" wrote:

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

vlookup and IF function
 

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" wrote:

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" wrote:

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