complex Vlookup question

M

matrix7410

Hello, I'm trying to do the following.
State Country
New York USA Jan 09
Populations 1.5 mil

Rio De Janeiro Brazil
Pouplation 2.5 mil

How would I do a vlookup where I'm matching the name New York and I
will need to pull the population (1.5 mil)Typically when we do
vlookup, it usually matches the Name and than looks for the column
index and in my case I would get Jan 09 if I put column index of 3.
So, how do I pull the populations based on the name? I tried using
sumproduct and it works, but I'm wondering if vlookup could work some
how. thanks!
 
J

John W. Vinson

Hello, I'm trying to do the following.
State Country
New York USA Jan 09
Populations 1.5 mil

Rio De Janeiro Brazil
Pouplation 2.5 mil

How would I do a vlookup where I'm matching the name New York and I
will need to pull the population (1.5 mil)Typically when we do
vlookup, it usually matches the Name and than looks for the column
index and in my case I would get Jan 09 if I put column index of 3.
So, how do I pull the populations based on the name? I tried using
sumproduct and it works, but I'm wondering if vlookup could work some
how. thanks!
Click to expand...

VLookUp is an Excel function, and I'm guessing that you're working in that
program; but this newsgroup is for a different program, the database software
Microsoft Access. If you're using Excel please repost in an Excel newsgroup;
if you're in Access post some more details of your table structure, I'm sure a
Query (or at worst a DLookUp call) can do what you want.
 
Top