lookup data
 

I have a spreadsheet with a column that must have a specific code inserted.
I have a separate spreadsheet with the code and correlated info. How can I
created a lookup field in that one column that allows me to choose from the
codes in the second spreadsheet as well as see the correlated info for each
code?

lookup data
 

Hi Jaci,

1. on sheet1 create a drop down box, and set the properties to look to your
data on sheet2, you should make a reference to another cell, lets say H1.

2. create a ID column on the left side of you data 1,2,3,4...etc.

3. assuming that you drop down box is on A2 use this formula in:

B2 =vlookup(sheet2!h1,sheet2!a2:a1000,3,false)
C2 =vlookup(sheet2!h1,sheet2!a2:a1000,d,false)


when you select a code on the drop down excel will show you the information
that you need.
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jaci" escreveu:

I have a spreadsheet with a column that must have a specific code inserted.
I have a separate spreadsheet with the code and correlated info. How can I
created a lookup field in that one column that allows me to choose from the
codes in the second spreadsheet as well as see the correlated info for each
code?