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

One way:

Sheet3 A1 = lookup_value

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

--
Biff
Microsoft Excel MVP


"Atif" wrote in message
...
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

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

On Sep 26, 5:34*pm, Atif wrote:
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

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)

"Atif" wrote:

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