Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |