Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Changing number grade to letter garde using the Lookup Formula.
Posted by - NA - on 30 March 2006 06:21 AM
|
|
|
Solution: 1. Assume you have a sample file: 2. Click on cell F2. Click on the Paste Function in the Standard Toolbar. 3. Click on All and find LOOKUP. 4. Click on LOOKUP and click OK. 5. Use the "Select Lookup value, array", and click OK. 6. Lookup_value is cell E2. Either click on it with the mouse or type in E2. Press the tab key on the keyboard. 7. Array is cells A7:B11. Either select them with the mouse or type in A7:B11. Press the F4 function key to make them absolute value. 8. Your screen should appear as below: 9. Click on OK and AutoFill down. Note: you could put the information in cells A7:B11 on a separate worksheet. | |
 (123 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)