how do I create a vlookup?
 

I am trying to create a VLookup formula where I am trying to have the
District Manager automatically put into Cell A2 for each particular store. I
have the columns where the store # and the DM name are off to the left side
of the data I will be manually entering in. My problem is getting the
VLookup formula to work. I am not new to Excel but I am new to VLookups.
Any help would be greatly appreciated. Thanks!

how do I create a vlookup?
 

You need a table of two columns
left column is the store# (sorted in ascending order)
second column the names
say you are going to enter them in R1 to S20
The vlookup formula will be in cell A2
=vlookup(B2,$R$1:$S$20,2,false)

you can extend this down the A column as far as you need to.

--
Greetings from New Zealand
Bill K
"Jamie" wrote in message
...
I am trying to create a VLookup formula where I am trying to have the
District Manager automatically put into Cell A2 for each particular store.
I
have the columns where the store # and the DM name are off to the left
side
of the data I will be manually entering in. My problem is getting the
VLookup formula to work. I am not new to Excel but I am new to VLookups.
Any help would be greatly appreciated. Thanks!

how do I create a vlookup?
 

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html

Jamie wrote:

I am trying to create a VLookup formula where I am trying to have the
District Manager automatically put into Cell A2 for each particular store. I
have the columns where the store # and the DM name are off to the left side
of the data I will be manually entering in. My problem is getting the
VLookup formula to work. I am not new to Excel but I am new to VLookups.
Any help would be greatly appreciated. Thanks!

--

Dave Peterson

how do I create a vlookup?
 

It worked the first time I tried. Thank you very much. I've been working on
this for about an hour and just had it fixed and totally understand it now 5
minutes after reading your post.

"Jamie" wrote:

I am trying to create a VLookup formula where I am trying to have the
District Manager automatically put into Cell A2 for each particular store. I
have the columns where the store # and the DM name are off to the left side
of the data I will be manually entering in. My problem is getting the
VLookup formula to work. I am not new to Excel but I am new to VLookups.
Any help would be greatly appreciated. Thanks!