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