VLOOKUP

[Me]

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

 

[T. Valko]

Assume your data is in the range A1:E9. A1:E1 are column headers.

To find the rate for room code CF at Standard rate:

A15 = CF
B15 = Standard rate

=VLOOKUP(A15,A2:E9,MATCH(B15,A1:E1,0),0)

Result = 3200