Vlookup on Multiple Sheets

E

Excel_Oz

HI,

I think this may have been answered else where but I am having a hard
time sifting through what is important so I will ask again.

I have data in column a to g, in sheets 1 and 2. On sheet 3 I want to
look up a value in "A " and match that value to a number in column "A"
of sheet 1 or 2 (which ever sheet it appears in) and return the
information contained in column "G".

Is this possible and how do I go about doing this?

Thanks!!!
 
T

T. Valko

Here's one way:

=VLOOKUP(A1,IF(COUNTIF(Sheet1!A1:A5,A1),Sheet1!A1:G5,Sheet2!A1:G5),7,0)

Biff
 
Top