Excel Magic Trick 928: VLOOKUP Grading: Plus, Minus or Zero: Looking Up A Plus, Minus or Zero

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. See how to use VLOOKUP to lookup a Plus, Minus or Zero and return a number grade by sorting the VLOOKUP table 2. See how to use VLOOKUP to lookup a Plus, Minus or Zero and return a number grade by using Exact Match with a required sort on the VLOOKUP table