Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Excel claims there is an error in my formula below, but I cannot find it:
=VLOOKUP(A1,{"Ground",100;"Surface",100;"Next Day Noon",100;"Next Day 10:30 AM",100;"Next Day 3 PM",100;"2nd Day",100;"Next Day Air",100;"2nd Day Air",100;"Standard",100";"Priority Mail",0;"First-Class Mail",0;"Media Mail",0;"Parcel Post",0;"Bound Printed Matter",0;"Express Mail",100;"EMS",100;"Global Express Guaranteed",100;"Airmail Letter Post",0;"Airmail Parcel Post",0;"Economy Letter Post",0;"Economy Parcel Post",0;"Global Priority Mail",0;"Airmail Letter Post-Registered Mail-Canada",100;"Economy Letter Post-Registered Mail-Canada",100;"Airmail Letter Post-Registered Mail",43.93;"Economy Letter Post-Registered Mail",43.93},2,FALSE) Does anyone have any ideas?? This formula below DOES work though: =VLOOKUP(A1,{"DHL-Domestic",0.19;"FedEx-Domestic",0.19;"UPS-Domestic",0.19;"DHL-International",0.30;"FedEx-International",0.30;"UPS-International",0.30;"USPS-Domestic-Traceable",0.48;"USPS-Domestic-Non-Traceable",0.68;"USPS-International",0.98},2,FALSE) And the only thing different from the one above is that I just changed some values! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula doesnt work | Excel Worksheet Functions | |||
formula won't work | Excel Worksheet Functions | |||
formula won't work | Excel Worksheet Functions |