Please fix this problem, can not find a solution any where!

Dear All,

I am working on a spreadsheet, but there are certain issues and things i can not seem to fix.

Who is kind enough to help, its very important and really stressing me out

Some back ground

Its a room utilisation spreadsheet. We have 15 rooms in our department and we rent them out. Rates we charge for the room is depending on sort of booking e.g. If room user is internal then its free, if external user then some sort of charge and if internal ( but making money) then rate at discount rate.

I have prepared the whole spreadsheet 80% ready, but what i cant seem to do it, make the unique rates appear depending on type of booking and room booked and add the room hire price automaticcaly. There can be multiple room booked and all room have different rates.

Please can some one help.

Thanks

Wish i knew how to do it

Thanks- This is almost right but not exactly

i have got a drop down of and most of the time there r multiple rooms booked and how do i incorporate that..and hve total hire cost in a cell

should i send u wht i got ?