Take a look at VLOOKUP in XL Help.

In article ,
"carris76" wrote:

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!