Vlookup on Multiple Sheets

[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. Valko]

Here's one way:

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

Biff