how do I create a vlookup?

J

Jamie

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

Bill Kuunders

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

Jamie

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