Excel Forum
Similar Content
Vlookup with a Range of Numbers in Excel
Tutorial: How to use the Vlookup function to return a result that falls within a range of numbers, s...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...

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.