help with a vlookup

  • Thread starter Thread starter GW
  • Start date Start date
G

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.
 
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).
Click to expand...

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


Regards
Claus B.
 
Back
Top