Help with a list

C

Chris N

I am hoping someone can give me some advice on the
following problem I am having.
I have a list of 4,000 suppliers with addresses and phone
numbers in an excel spreadsheet. In a seperate
spreadsheet I am trying to figure out a way to select a
vendor from the list or a drop down and then automatically
populate the corresponding phone number and address. I am
sure this is possible but I can't figure out a way and
can't find anything on the help menu.
 
B

Bob Phillips

Use Data Validation to create a list linked to the first column of that
list, and then use VLOOKUP to get the rest

=VLOOKUP(A1,H1:K4000,2,FALSE) and
=VLOOKUP(A1,H1:K4000,3,FALSE)

See http://www.contextures.com/xlDataVal01.html for DV.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ruxpin

Chris,

You will want to either use the VLOOKUP function or "IF" statements within
Excel. Search under the Excel Help menue for these formulas, and they will
explain them to you in detail. I suggest using VLOOKUP which basically allows
you to specify a range and # of Columns/rows that your data is in. once you
import it or have the data set, the VLOOKUP formula will automatically enter
values that are in some table based on the Column position you specify in the
VLOOKUP formula.

Ted
 
Top