Hi
use Data Validation together with VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html
http://www.contextures.com/xlDataVal01.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Josh O." schrieb im Newsbeitrag
...
I am trying to make a spreadsheet with a customer list that pulls a
customer
number and name from another spreadsheet and places them
alphabetically (with
corresponding customer number) onto the spreadsheet I am using.

Is there a way to do this?