VLOOKUP Between Sheets

M

MB

I need help with a formula, please. I have two sheets: Sheet 1 is a
purchase order form. Sheet 2 holds the following:

Col A Col B
BG Bag
BX Box
YD Yard
FT Feet

I used Data Validation to create the drop down box in the Purchase Order and
named B1:B4, above, as "Description." The choice would be from
"Description," but the value to be returned should be from Column A (the
abbreviations).

I am using 2003.

Thank you!
 
B

Bob Phillips

In an adjacent cell

=INDEX(Sheet2!A:A,MATCH(B1,Sheet2!B:B,0))

where B1 is the DV cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
M

MB

Thanks, Bob. Which sheet do I put this formula in? And adjacent to which
cell?

Thank you so much for your help.
 
B

Bob Phillips

In the sheet that the Data Validation is in, i.e. not Sheet2, and adjacent
to the DV (you can put it anywhere as long as you reference the DV cell, B1
in my example, it just seems more sensible to be adjacent).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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