LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Julie P.
 
Posts: n/a
Default My formula does not work!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get a formula to work in each row of an Excel sheet. JessicaMc Excel Worksheet Functions 2 June 8th 05 08:11 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula doesnt work Kevin Excel Worksheet Functions 2 February 24th 05 12:57 AM
formula won't work tink13ub Excel Worksheet Functions 1 January 17th 05 06:59 AM
formula won't work Linette Excel Worksheet Functions 0 January 17th 05 06:05 AM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"