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