In need of a formula

I am using Excel 2003 and have run up against the limit of embedded IF statements. I am currently using the formula:

=IF(D34="Legends Hall",(350*C34),IF(D34="Executive Level",(200*C34),IF(D34="Club House Lounge",(200*C34),IF(D34="Miller Suite 3",(150*C34),IF(D34="Miller Suite 2",(150*C34),IF(D34="Miller Suite 1",(150*C34),IF(D34="Miller Suites 1&2",(200*C34),IF(D34="Miller Suites 2&3",(200*C34),("")))))))))

The formula is doing exactly what I need it to do, but I have more rooms that I can't put in. Is there a different formula that will accomplish this for me?

Thanks in advance

I would first create an index table which lists the suite levels and costs per day.

then use the formula:

=vlookup(d34,A1:B10[or where your index table is],2,0)*c34

the index table would look like

Legends hall || 350
Executive Level || 200
etc.