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!

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!

Sorry, should be VLOOKUP


"Trevor Shuttleworth" wrote in message
...
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!

Use VLOOKUP()

Say we have a table in cols E & F:

100 Larry
113 Moe
117 Curly

Your table will be much longer.

In A1 put the number, say 113, and the following formula in B1:

=VLOOKUP(A1,E1:F3,2,2) and B1 will show the looked-up value:
Moe

--
Gary's Student


"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!

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!