Populate cell with dollar value based on text criteria and dollar value in separate cells

I have a spreadsheet that I need to calculate a dollar amount in a particular cell.

The calculation is based on the text content of another cell which leads to one of three cells containing the dollar value.

i.e. In my total cost column cell BZ8 needs to reference cell N8 and determine whether N8 contains either "King" "Twin" or "Suite". Based on that result it then needs to get the dollar figure from one of three cells containing the relevant price for each of the above options. The King value is located in L2, Twin in L3, Suite in L4. Once it's determined what type of room it is based on the text I then want it to popular BZ8 with the relevant dollar amount.

I'm not sure if this is an If formula or and OR formula or something else entirely.

Any help would be much appreciated.

I actually need it to look for the specific text to then determine which cell it goes to to pull the pricing if that makes sense?

Try this in BZ8

Please Login or Register  to view this content.