Codes

H

Heather

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

Trevor Shuttleworth

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

Regards

Trevor
 
T

Trevor Shuttleworth

Sorry, should be VLOOKUP


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

Regards

Trevor
Click to expand...
 
G

Gary''s Student

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
 
D

Difficult1

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.
 
Top