Prefill cust info from drop list into other cells

carris76 · May 28, 2005

I created a drop down list of Cust ID's. I have several cells containing
customer name, address, phone etc. that I want to prefill from the
spreadsheet that my CustID's came from, but I don't know how!

JE McGimpsey · May 28, 2005

Take a look at VLOOKUP in XL Help.

Gord Dibben · May 28, 2005

Sounds like VLOOKUP could do the trick.

For more on that Function see Debra Dalgleish's site.

http://www.contextures.on.ca/xlFunctions02.html

Also see Debra's site for info on Data Validation lists with drop-down box for
entering the code numbers.

http://www.contextures.on.ca/xlDataVal01.html

Might be useful.

Gord Dibben Excel MVP

Prefill cust info from drop list into other cells

carris76

JE McGimpsey

Gord Dibben