help with a vlookup

[GW]

Hi

On Sheet1, column A, I have a list of items.

On Sheet2, column A, I have a subset of the list plus a corresponding value in column B (call this value X).

I need a function (vlookup?) that will return X, on Sheet1, column B, where the value in column A matches across Sheet1 and Sheet2.

I've fiddled about with vlookups and can't seem to get it to work.

Any help appreciated.

 

[Claus Busch]

Hi,

Am Tue, 25 Mar 2014 08:42:27 -0700 (PDT) schrieb GW:

On Sheet1, column A, I have a list of items.

On Sheet2, column A, I have a subset of the list plus a corresponding value in column B (call this value X).

in B1 of Sheet1:
=VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0)


Regards
Claus B.

 

[gareth.wretham]

That works - thanks so much! I wasn't including column B in the array...