Not sure if there is an easier way to do it than to use 3 vlookups. Assuming
the value to look up is in A1, the lookup tables are in cells A1:A3 of
Sheet2, Sheet3, and Sheet4:

=IF(ISNUMBER(MATCH(A1,Sheet2!A1:A3,0)),VLOOKUP(A1, Sheet2!A1:B3,2,0),IF(ISNUMBER(MATCH(A1,Sheet3!A1:A 3,0)),VLOOKUP(A1,Sheet3!A1:B3,2,0),IF(ISNUMBER(MAT CH(A1,Sheet4!A1:A3,0)),VLOOKUP(A1,Sheet4!A1:B3,2,0 ),"")))


"Christine" wrote:

Is it possible to do a vlookup across three seperate spreadsheets?