VLOOKUP
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 |
VLOOKUP
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 -- Biff Microsoft Excel MVP "Me" wrote in message ... 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 |
All times are GMT +1. The time now is 11:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com