Vlookup Data Split

[Atif]

Hi

Data is split in two sheets, can I vlookup both sheet in single formula.
i.e.
Sheet 1 (half data)
Sheet 2 (half data)
Sheet 3 (vlookup)

Thanks

 

[T. Valko]

One way:

Sheet3 A1 = lookup_value

=VLOOKUP(A1,IF(COUNTIF(Sheet1!A1:A10,A1),Sheet1!A1:B10,Sheet2!A1:B10),2,0)

 

[Pete_UK]

Another way:

=IF(ISNA(vlookup1),IF(ISNA(vlookup2),"not present",vlookup2),vlookup1)

where vlookup1 will be looking for an exact match in Sheet1, and
vlookup2 will be looking for an exact match in Sheet2, so might look
something like:

VLOOKUP(A2,Sheet1A:F,6,0)

(example only).

Hope this helps.

Pete

 

[Sean Timmons]

Are you looking for a result in one OR the other, or one AND the other? (i.e.
- want to know if the value is in sheet A, if not, look in sheet B VS. Find
the lookup in sheet A and add to the lookup in sheet B)