Lookup value in first column given a row value.

[Adamitus]

Hi,

I have a table with first column countries and in the first row years and i have their GDP for each year and country. My question is if in a separate cell i have a certain GDP number i want to get in another cell the country it belongs to. I tried to do it with index and match functions but the match function shows N/A do to the lookup array is to big.

Much appreciated,

[Pete_UK]

Give us a few cell/column references and sheet names, or post an example file.

Pete