I would use a vlooup formula.... on a blank sheet enter your sales people
with their numbers:

1056 Joe Smith
1398 Priscilla Nathans

So on and so forth... then in cell b1 on your working sheet enter a vlookup
formula:
=VLOOKUP(A1,Sheet1!$A$1:$B$3,2)... A1 in this case is on the sheet you are
working on.... where you are entering the sales persons number, Sheet 1
contains the names and numbers of the sales reps.... these need to be in
order by the look up value... in other words... you need to sort by column a
in your range. the "2" is the second column of the range, the employees
names. I can email you something if you would like.


"Heather" wrote:

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!