Trouble with looking up value

I am trying to create a formula to return a value that is dependant on multiple criteria. I figured it would be easier to show an example versus trying to explain everything.

In this example I want to find the interval value associated with the criteria (city and floor) of the different scenarios. the interval is dependant on the city and on the floor associated with each difference scenario so row and column numbers (using match) are always different.

basically how I need it to look up is like this.
Find city in first row
find value right above the floor
return interval

i feel I could do this with an index match, but the issue is it asks for a row first when I find the column first and the row is dependant on which column I am looking in.

example.xlsx

You can use this formula in G3:

Formula:

Please Login or Register  to view this content.

then copy down.

Hope this helps.

Pete

that was fast...thanks!!

actually small issue.

I was trying to write VBA code to computer this as well. seems there is an issue with ahving the 0 as the row in the 2nd index function. any idea on how to get around it?

got it nvm