I am trying to do a look up based on three variables. The firs
variable determines the worksheet and the second and third ar
variables within the various worksheets

An example is the first variable is a region with a country and th
second and third variables are cities within the region and the answe
that comes back is the distance between the cities.

Any help would be appreciated

--
Message posted from http://www.ExcelForum.com

Use the indirect worksheet function to form a dynamic range - to inject the
correct sheet.

Use

offset(base range ,Match for row, Match for column)

assumes you have a list of cities down the column and across the top with
the distance at the intersection.

--
Regards,
Tom Ogilvy


"mikey6704 " wrote in message
...
I am trying to do a look up based on three variables. The first
variable determines the worksheet and the second and third are
variables within the various worksheets

An example is the first variable is a region with a country and the
second and third variables are cities within the region and the answer
that comes back is the distance between the cities.

Any help would be appreciated!


---
Message posted from http://www.ExcelForum.com/

Thanks Tom. I have seen several post using the indirect function, but
have never worked with it. I did getting it doing what I was lookin
for. Very useful little tool

--
Message posted from http://www.ExcelForum.com