Multiple Lookup/Index/Match Help!!

Hello,

I need to pull data from many different sheets into one reference sheet, which then will be used to make calculations and linear projections. I want these sheets to remain separate files for diverse reasons, but I need to call data based on two criteria and cannot get an index or match or lookup function to work.

In every sheet, column A has a country name (e.g. Armenia or France). Column E always has a year (ranging from 1975 to 2009). Not all sheets have the same number of years or countries - so for example, Workbook 1 Sheet 1 might have France 1999, France 2000, and France 2003, while Workbook 2 may only have France 2001 or not have France at all.

I need to call all of the values in columns F to __ in each workbook into one sheet. I have every country in the world and every year from 1975 to 20009. So essentially, I need to call data from the other workbooks/sheets to say, if Column A = country (e.g. Armenia) AND Column E = year (e.g. 2000) then paste the corresponding H or M or T value, etc etc.

Can someone please help with this? I've tried so many combinations with index and match and I keep getting #N/A or Value

Thanks,
John

Post up a demo file of what you want done, it does not have to include every sheet, just a sample to see what you need. It is hard to see what you want just by the explanation.