« Auto Filling Cells
Looking up data in tables II »

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

This entry was posted on Monday, September 13th, 2004 at 7:01 pm and is filed under Function Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Looking Up Data In tables I”

  1. John Says:
    July 29th, 2007 at 3:58 am

    I’m having trouble with lookup if I try to lookup on a different sheet -it doesn’t seem to work?

Leave a Reply