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!

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" <[email protected]> wrote in message
news:[email protected]...
>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 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

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!