Sounds like you need to use VLLOKUP and pick up the details from a Master
List of Sales Rep details somewhere

Regards

Trevor


"Heather" wrote in message
...
Can anyone help me with this:

I would like to set up a sheet so I can type a number in the A1 cell & a
Sales Rep's Name will appear in B1. I am working on creating quote sheet
for work and I want to be able to tie numbers to specfic descriptions.

Thank You!