Hi!
Assume lookup value is in sheet1 A1.
The first lookup table is in sheet2 A1:B5.
The second lookup table is in sheet3 A1:B5.
=IF(ISERROR(VLOOKUP(A1,Sheet2!A1:B5,2,0)),IF(ISERR OR
(VLOOKUP(A1,Sheet3!A1:B5,2,0)),"",VLOOKUP(A1,Sheet 3!
A1:B5,2,0)),VLOOKUP(A1,Sheet2!A1:B5,2,0))
Biff
-----Original Message-----
I would like my vlookup function to look for a value in
one sheet and if it
doesn't find it, look in another sheet. Is this possible?
I was considering using a nested if function but not sure
how.
.
|