complex Vlookup question

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!

On Fri, 9 Jan 2009 14:41:10 -0800 (PST), wrote:

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!

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

John W. Vinson [MVP]