### Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem

Download file: http://people.highline.edu/mgirvin/ See what happens when a formula uses a column that is sorted. After the column is sorted, the formula does not work, but VLOOKUP function will fix the problem. See formula to calculate total amount spent. See a worksheet reference in a formula.

Length:
06:38