Using VLOOKUP for many values

[yosh]

Hello,

I am trying to use vlookup to organize a few tables of data. What I'm trying to do is organize by country, then align the population, unemployment rate, etc. parameters to the respective countries. The main problem is that some of the lists of data (like unemployment rate) have a smaller list of countries.

How can I use vlookup to align everything and skip over the countries whose data for the paramater I want aren't there? Ultimately, the data in those cells should be blank, 0, or N/A.

I know I haven't done a very good job of explaining this, so I've attached a link to the excel file. What I want to end up with is what is by the end result.

The excel file is here: Click to see the file

Thanks for any help.

[martindwilson]

see sheet 1 i used index/match rather than v lookup