software

Can anyone help me with this:

I would like to set up a sheet so I can type a number in the A1 cell amp; 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

Trevorquot;Heatherquot; gt; wrote in message
...
gt; Can anyone help me with this:
gt;
gt; I would like to set up a sheet so I can type a number in the A1 cell amp; a
gt; Sales Rep's Name will appear in B1. I am working on creating quote sheet
gt; for work and I want to be able to tie numbers to specfic descriptions.
gt;
gt; Thank You!
Sorry, should be VLOOKUPquot;Trevor Shuttleworthquot; gt; wrote in message
...
gt; Sounds like you need to use VLLOKUP and pick up the details from a Master
gt; List of Sales Rep details somewhere
gt;
gt; Regards
gt;
gt; Trevor
gt;
gt;
gt; quot;Heatherquot; gt; wrote in message
gt; ...
gt;gt; Can anyone help me with this:
gt;gt;
gt;gt; I would like to set up a sheet so I can type a number in the A1 cell amp; a
gt;gt; Sales Rep's Name will appear in B1. I am working on creating quote
gt;gt; sheet
gt;gt; for work and I want to be able to tie numbers to specfic descriptions.
gt;gt;
gt;gt; Thank You!
gt;
gt;
Use VLOOKUP()

Say we have a table in cols E amp; F:

100Larry
113Moe
117Curly

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 Studentquot;Heatherquot; wrote:

gt; Can anyone help me with this:
gt;
gt; I would like to set up a sheet so I can type a number in the A1 cell amp; a
gt; Sales Rep's Name will appear in B1. I am working on creating quote sheet
gt; for work and I want to be able to tie numbers to specfic descriptions.
gt;
gt; 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 quot;2quot; is the second column of the range, the employees
names. I can email you something if you would like.quot;Heatherquot; wrote:

gt; Can anyone help me with this:
gt;
gt; I would like to set up a sheet so I can type a number in the A1 cell amp; a
gt; Sales Rep's Name will appear in B1. I am working on creating quote sheet
gt; for work and I want to be able to tie numbers to specfic descriptions.
gt;
gt; Thank You!