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

[MarvinP]

Hi Bruce2E44,

Yep a VLookup will work but the how many rows over needs an If statement it in. Put the following in E2 and pull the formula down.

=VLOOKUP(B2:B2,'Lookup Table'!$A$5:$E$12,IF(D2="AD",3,IF(D2="ST",4,5)),FALSE)

I think that will do ya.

[Bruce2E44]

Thank you very much. I tried using the IF argument just never thought of using it on the how many rows section. Thanks again and it works perfect.