Forgive my ignorance here guys, but I am lost!
I am attempting to input a formula to determine the rate charged for each room rental. My Initial worksheet looks like this. I need to input the rate into column C. The rate is determined by both column B and column E.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I have created the lookup table below to determine the dollar amount of the rate.
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
So basically what I need excel to do is say IF (on the 1st worksheet) column B equals AL AND column E equals AD THEN the result is cell C5 in my lookup table (on the second worksheet), but I have no idea how to do this.
Any suggestions?
Thanks!
~T
<tbody>
</tbody>
I am attempting to input a formula to determine the rate charged for each room rental. My Initial worksheet looks like this. I need to input the rate into column C. The rate is determined by both column B and column E.
ResNo | Room# | Daily Room Charge | CustNo | RateCode |
R0010 | AL | C0001 | AD | |
R0010 | CA | C0001 | AD | |
R0011 | CO | C0002 | ST | |
R0012 | FL | C0003 | ST | |
R0017 | AL | C0005 | ST | |
R0017 | CA | C0005 | ST | |
R0017 | CO | C0005 | ST | |
R0017 | FL | C0005 | ST | |
R0017 | GA | C0005 | ST | |
R0003 | CA | C0006 | AD |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I have created the lookup table below to determine the dollar amount of the rate.
Room Code | Meeting Room | AD - Advance Rate | ST - Standard Rate | SP - Special Rate |
AU | Auditorium | $2,418.75 | $2,925.00 | $1,735.00 |
BD | Boardroom | $1,912.50 | $2,550.00 | $1,330.00 |
CF | Conference Center | $2,475.00 | $3,200.00 | $1,900.00 |
AL | Alabama | $1,950.00 | $2,300.00 | $1,390.00 |
CA | California | $1,987.50 | $2,350.00 | $1,422.50 |
CO | Colorado | $1,968.75 | $2,325.00 | $1,375.00 |
FL | Florida | $1,950.00 | $2,300.00 | $1,390.00 |
GA | Georgia | $1,931.12 | $2,275.00 | $1,431.25 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
So basically what I need excel to do is say IF (on the 1st worksheet) column B equals AL AND column E equals AD THEN the result is cell C5 in my lookup table (on the second worksheet), but I have no idea how to do this.
Any suggestions?
Thanks!
~T
<tbody>
</tbody>