software

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!

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
quot;Jamiequot; gt; wrote in message
...
gt;I am trying to create a VLookup formula where I am trying to have the
gt; District Manager automatically put into Cell A2 for each particular store.
gt; I
gt; have the columns where the store # and the DM name are off to the left
gt; side
gt; of the data I will be manually entering in. My problem is getting the
gt; VLookup formula to work. I am not new to Excel but I am new to VLookups.
gt; Any help would be greatly appreciated. Thanks!
You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html

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

--

Dave Peterson

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.

quot;Jamiequot; wrote:

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