ArticlesBlog Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions September 10, 201911 Related posts: Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT? Related tags : Array Formulas BI 348 Business Analytics Calculate Shipping Charge shortest distance Ctrl Shift Enter Mastering Excel Array Formulas Data Analysis Excel Excel Magic Tricks excelisfun Highline College IF Function IF function minimum shipping INDEX function Lookup min shipping miles each customer return correct Shipping Center MATCH function Michael Girvin Microsoft Excel Mike excelisfun Girvin Mike Girvin MIN function Slaying Excel Dragons Unusual Lookup Post navigation Previous Article My Biggest Mistakes in Business | Simon Kallu at GrowFactor Next Article Cottage food laws California 10 Things You MUST know Home based food business Comments (11) September 26, 2015 at 4:09 pm super… many thanks… ; D Reply September 26, 2015 at 4:38 pm Nice one! Excellent stuff on "smart" spreadsheets. Reply September 26, 2015 at 5:41 pm These formula are so cool. Thanks for uploading. Reply September 26, 2015 at 6:47 pm cool…by using a formula how do i pull the values from the entire row or column just by using a single cell reference.? do you have any video of it.? Reply September 26, 2015 at 7:03 pm You can use MAX formula to calculate Shipping Charge, like =MAX(miles*price, 75) Reply September 27, 2015 at 1:20 am @Francis Osuna, Glad you like it! Reply September 28, 2015 at 3:48 am This was amazing! I tried following this tutorial using Numbers (from Apple) and it still worked really well. Just a little slow since locking down cell references isn't quite the same as it is with Excel! Reply September 28, 2016 at 11:09 pm I love it! Eu adorei isso! Agora em usando Excel em Ingles Reply December 11, 2017 at 4:19 pm you make me feel proud of myself because every single day you teach me something new and i really do appreciate thank you Mr. Mike Reply December 16, 2018 at 9:45 pm Thanks Reply June 14, 2019 at 1:07 am Mike great videos and energy in delivering the material, thank you again! Reply Comment here Cancel reply Comment Name * Email * Save my name, email, and website in this browser for the next time I comment.