I'm trying to lookup column A and column H in the first tab in the table on the second tab.

Please see attached. This is the formula I've come up with but it's not working. I feel like I'm close though.

{=INDEX('Rate Chart'!$A$1:$K$151,MATCH('2day'!A2&'2day'!H2,'Rate Chart'!$A$2:$A$151&'Rate Chart'!$B$1:$D$1,0))}

So for the first row, I want it to return 14.99.

For the second row, I want it to return 8.49

Can someone please help? Would highly appreciate it.

-S

Lookup Multiple Criteria.xlsx