match data from 2 columns and then return value from a 3rd one

[excel_try]

hello,

1. i am comparing text
2. i have >100 countries, and with vlookup i have to type every single one, and this is what i want to escape (mb i need to refer to an array, or string, or no idea)
3. mb a solution could be sth with index, or match, i just tried it, copying some similar formula from www, but it didn't match the countries, and return the value respective for that country.

E.g. I have China in col1 (1st file), #employees 10 in col2 (1st file), and China in Col 1 in 2nd file. So, a formula should match China & China from both files, and return 10 as number of employees.

If you see a solution, pls. let me know,

thx a lot...

[Mallycat]

vlookup will do what you want. Make sure your first sheet is sorted in alpha order (by country). Click in cell B1 of your second sheet and enter the function wizard (Fx near the data entry point below the toolbars). Find vlookup by typing it into search. The lookup value is the data in cell A1 (ie the first country), table array is all data in the first sheet. Make sure you use absolute references (ie $A$1:$b$100), column index =2, Range lookup = 0

[EdMac]

Please don't cross post across the sections

http://www.excelforum.com/excel-work...-is-found.html