help with a vlookup


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.
 
Ad

Advertisements

C

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top