Match and Index function

Dear All

Appreciate if you would help

As attached a small table

Listed the dates and hotel prices
I tried to use + index & Match function
However, i want to returned a figure which is lower or equal to the input

For example :
02-Jan 05-Jan 07-Jan 08-Jan 10-Jan
Ramada Hotel 50 90 40 50
Park Hotel 10 12 10 15

Date 05-Jan 06-Jan 07-Jan
Ramada Hotel 90 90 40

I want to get the rates on 6-Jan, which is smaller than 7-Jan
in this case, it should run 90

How can i do that..

Thanks

On Cell D8:

Please Login or Register  to view this content.

You have a space at the end of Ramada Hotel in cell B8, so I suggest your remove that, and then you can use this formula in D8:

=INDEX($C$4:$G$5,MATCH(TRIM($B8),$B$4:$B$5,0),MATCH(D$7,$C$3:$G$3))

then you can copy this across into E8:F8.

The TRIM function (shown in red) is only needed if you don't remove the space in B8.

Hope this helps.

Pete

Exactly how Pete explained