I nned help. I need to bring back the daily room charge into my main
worksheet from the look table. The lookup table is below. So depending on
the room code and the rate code I am not sure how to set this up? I am
really lost.

Room Code Meeting Room Advance Rate Standard Rate Special Rate
AU Auditorium $3,000.00 $2,925.00 $1,735.00
BD Boardroom $1,912.50 $2,550.00 $1,330.00
CF ConfCenter$2,475.00 $3,200.00 $1,900.00
IL Illinois $1,950.00 $2,300.00 $1,390.00
IN Indiana $1,987.50 $2,350.00 $1,422.50
WI Wisconsin $1,968.75 $2,325.00 $1,375.00
MI Michigan $1,950.00 $2,300.00 $1,390.00
IA Iowa $1,931.12 $2,275.00 $1,431.25