Multiple Matches with INDEX Problem

Hi All,

i am using Index Match in cell c11 in my attached file to find out the rate but there is problem. i have to match three values then find Rate value from column L,M,and N. can anybody tell me how i can use three matches with INDEX formula? is there any other way to find this by Vlookup or IF conditions?

Thanks.

Majid

Thanks Special-L,
Fantastic, perfect, can you tell me, is it possible by INDEX match formula?
Thanks

For C6 how about
=INDEX($J$4:$N$12,MATCH(C6&"|"&C7,INDEX($I$4:$I$12&"|"&$J$4:$J$12,0),0),MATCH(C6,$J$3:$N$3,0))

Thanks to reply Fluff13,
your formula is giving results 110 but actual is 80. C6, C7 and C8 also criteria.

I should have said that formula was for C11 not C6, but it returned 130, which is what Special-K's formula returned & you said was correct.
This also returns 130
=INDEX($J$4:$N$12,MATCH(C7&"|"&C8,INDEX($J$4:$J$12&"|"&$K$4:$K$12,0),0),MATCH(C6,$J$3:$N$3,0))

This is perfect Fluff13,
Thanks a lot, its cheers,
your previous formula post #5, when i changed room type then its not working but last one perfect.
thanks boss Special-K and Fluff13,
Thanks

Glad to help & thanks for the feedback