Posted to microsoft.public.excel.worksheet.functions
|
|
Vlookup
IT WORKS!!! Thank-you!!!
"Max" wrote:
How about something like this, in say Sheet3's B1:
=IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,0)),IF(ISNA(VLOOK UP(A1,Sheet2!A:B,2,0)),"",VLOOKUP(A2,Sheet2!A:B,2, 0)),VLOOKUP(A1,Sheet1!A:B,2,0))
Above looks A1 up in Sheet1, then in Sheet2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thecdnmole" wrote:
No, if I am looking for 150, it wouldn't be on the first worksheet with
numbers from 1 - 100, but I don't know that from my search page. Also the
numbers are randon, not in order.
|