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/