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