Excel Forum

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.

Got a Question? Ask it Here in the Forum.