This is getting me closer. The problem is that there is multiple ranges on
each sheet that i need to access. Is there a way to continue using the range
ie, B2:N53 for this function and then other for different functions but have
the sheet name only change by entering it into a cell on the main page.

jeff

"Rlmccants" wrote:


Try this...


=VLOOKUP(F12,Indirect($B$1),2,0)

In cell B1, you can enter the country name such as France.


Also, for each country, go to the respective sheet, select this range
B2:N53, and name the country...France, Greece, Italy, etc. Populating
cell B1 with the same name.


--
Rlmccants
------------------------------------------------------------------------
Rlmccants's Profile: http://www.excelforum.com/member.php...o&userid=26097
View this thread: http://www.excelforum.com/showthread...hreadid=395131