Hi there,

I'm stuck and need some help with getting an Index/Match formula to work.

I have attached my file in case anyone is able to help me out. I need to calculate the time target to set depending on two criteria in cells A3 and B3. Cell C3 currently shows my attempt to create an INDEX MATCH where by the formula looks up the details in A3 and B3 and returns the answer based upon the table in A5:B5. In column B I would like the match formula to find the largest value that is less than or equal to the lookup value in B3.

Unfortunately the formula I have done isn't working properly.

I am probably doing something very silly so hope someone can point me in the right direction?

Thanks,
Al

LocationTest.xlsx