Frank,
Forgive me, I don't see how that will help put the list in alphabetical
order. I am not familiar at all with the data validation, and only a little
with the vlookup. I have used the lookup function alot.

Can you offer me detail as to how the two functions may help?

"Frank Kabel" wrote:

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?