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!