hongdo310.blogspot.com
Hong's EDM310 blogWednesday, April 26, 2006. Create a VLookup TAble. Type in two separate row. The numerica value and the equal letter. Must be in ascending order, which mean from lowest to highest. Then, locate things to be look up. Click on the letter grade cell. Insert function look up $ ref. vlookup. ON Look up value. Type: the box to be look up which is the Final grade(after bonus cal.). Type: the value of 0 to the 90. On Col.index. Num type: 2 because its the column #2 that we are working on. Adj or add Bonus. Poste...
http://hongdo310.blogspot.com/