Vlookup

[Bruce2E44]

Good evening all, I've been at my wits end here trying to figure out how to get VLOOKUP to do what I'm asking it and after doing a few searches I've realized VLOOKUP might not work for what I need.

What I'm looking to do (spreadsheet attached) is to find a daily rate by looking at two separate codes and matching the price on the table. On the worksheet I have a room code and the type of rate (AU and ST for example). So for each room there can be 3 different rates. I tried using VLOOKUP to find the AU code in the lookup table but I can only get it to give me the first value in the next column.

To find the daily rate the formula needs to look at the room chosen, the room rate assigned, and return the value from the table.

Could anyone lend me a hand here? Thank you.

Bruce