I have tried your advise and found that the problem is solved for that
paticular range but will not solve my problem for other ranges on the same
county sheet. Is there a way to make just the sheet name variable. I thought
there might be a way to imbed a function inside a function but have been not
be able to get it to work correctly. Do you have any other suggestions.

Thank you in advance
Jsteele

"jsteele" wrote:

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