Apply Formula

Suppose you are working in OpenOffice Calc and you are writing some functions. And you want to apply this function to large number of column cells. You can do it by dragging the formula upto the last cell. But dragging is some times a very boring or tedious job. So let us check two simple ways to accomplish this task.

The vlookup or Vertical Look Up Function in Openoffice calc can be used to search a range of cells.Suppose you have two spreadsheets and you want to append data from one sheet to another. We can use vlookup() in open office calc to accomplish this task. vlookup() searches for values in one column and given values in another column in true condition. Read on to know how to user VLookup. The syntax for vlookup() is VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)