« Auto Filling Cells | Main | Looking up data in tables II »

September 13, 2004

Looking Up Data In tables I

Here is a simple grading example to illustrate how VLOOKUP can make life easy for you.

In the formula, the final argument 1 (TRUE) tells OpenOffice Calc that the lookup column is ordered and an exact match is not necessary. The closest match that does not exceed the lookup value is returned - which is exactly what we want.

vlookup1.jpg

Posted by Dave at September 13, 2004 05:20 AM

Comments

Post a comment




Remember Me?