I have a question about combo boxes in excel
A B C D E
1 Megan Davis Convention Center p49 fig 2
2 Daily Meeting Room Rates
3 Code Meeting Room Advance Rate Standard Rate Special Rate
4 AU Auditorium $2,418.75 $2,925.00 $1,735.00
5 BD Boardroom $1,912.50 $2,550.00 $1,330.00
6 CF Conference Center $2,475.00 $3,200.00 $1,900.00

My work is to create three combox list under formal control tab
The first combox list named as Meeting room type includes: Auditorium, Boardroom, Conference Center
The second combox list named as Roomrate includes: Advance Rate, Standard Rate, Special Rate
The last one named Days includes: 1,2,3,4,5

After creating these combo box. I have to calculate the total charge based one what type, room, and day that customer pick

I am using Vlookup and nestif to do that but it show me the false value.
Please help me with this one