Excel Forum
Similar Content
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...
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...
VLOOKUP() Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when yo...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.