- dotTech - https://dottech.org -

How to use VLOOKUP function in OpenOffice spreadsheets [Tip]

OpenOffice Calc is an application that includes a variety of spreadsheet functions.  VLOOKUP is one of its functions you can add to spreadsheets. With that you can look up data from within a table.

Let’s suppose you have a spreadsheet table listing packages and their contents. Set up a small table by entering package 1, package 2 and package 3 in one column. Then add toys, films and books in an adjacent column. The spreadsheet should match the one in the shot below.

VLOOKUP [1]

Now enter package 2 in another cell. Click a cell to add the VLOOKUP function, and press the fx button to open window below. Then select VLOOKUP from the list of functions.

VLOOKUP3 [2]

Press the button beside the Search criterion field to select the cell you entered package 2 in. Then click the button next to array to select the range of table cells. Enter 2, otherwise the second column, in the Index field as below.

VLOOKUP4 [3]

Press OK to add the function to cell. The VLOOKUP cell will now include films in it as below. So its found what’s in package 2 on our table.

VLOOKUP5 [4]
Now delete package 2 and enter package 1 in the look up cell as in the snapshot below. The VLOOKUP cell will then include toys when you press Enter. As such, you can adjust the column 1 data entered in the reference cell to find out what’s in the same row of column 2.

VLOOKUP6 [5]

VLOOKUP is a handy addition to spreadsheets. You can use this function to quickly find data in more extensive tables. This video [6] also shows you how to add the VLOOKUP OpenOffice spreadsheets.