complex Vlookup question

  • Thread starter Thread starter matrix7410
  • Start date Start date
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 would prefer to use vlookup. thanks!
 
Or, try using MATCH within an INDEX formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software







- Show quoted text -
Click to expand...

Can you please write the formula that you have in mind and I will than
take it from there? thanks!
 
Use match for column F where contains ny> add 1>now use index to find the
population in col F. Assumes the same layout for all.

=INDEX(H10:H22,MATCH("ny",F10:F22)+1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Or, try using MATCH within an INDEX formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software







- Show quoted text -
Click to expand...

Can you please write the formula that you have in mind and I will than
take it from there? thanks!
 
Back
Top