VLookUp

  • Thread starter Thread starter EH003268
  • Start date Start date
E

EH003268

I need to lookup data in worksheet2, and if it is not there i want i
to look up in worksheet3.
I have curentl
=IF(VLOOKUP(A1,Sheet2!1:65536,1,FALSE)?????,VLOOKUP(A1,Sheet3!1:65536,1,FALSE))

My data is coming from Queries so i cannot stack the tables in on
sheet
Can you help
 
just use isna
=IF(ISNA(VLOOKUP(1,Sheet2!1:65536,1,0)),VLOOKUP(1,Sheet3!1:65536,1,0))
 
Hi

You'll need to enclose your first IF in an ISERROR function, to check for an
error:
=IF(ISERROR(VLOOKUP(A1,Sheet2!1:65536,1,FALSE)),VLOOKUP(A1,Sheet3!1:65536,1,
FALSE),VLOOKUP(A1,Sheet2!1:65536,1,FALSE))
I can't quite follow your logic, though, because VLOOKUP checks columns for
values and you are giving it rows. Maybe it's just me!
 
Hi
try

IF(ISNA(VLOOKUP(A1,Sheet2!1:65536,1,FALSE)),IF(ISNA(VLOOKUP
(A1,Sheet3!1:65536,1,FALSE)),"",VLOOKUP(A1,Sheet3!
1:65536,1,FALSE)),VLOOKUP(A1,Sheet2!1:65536,1,FALSE))
 
Back
Top