another look-up problem(three variables)

M

mikey6704

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
 
T

Tom Ogilvy

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.
 
M

mikey6704

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
 
Top