Download file name: OpenOffice.org :: Using formulas to find Calc data
Calc offers numerous methods to find data in a sheet. For example, Edit -> Find & Replace moves the display cursor based on simple and advanced searching. Use Data -> Filter to limit what is displayed rather than simply moving the cursor.
Calc also offers lookup functions used in formulas. This article shows how you can search data using VLOOKUP, HLOOKUP, LOOKUP and MATCH functions. It will be explained with simple and advanced examples.
Author: Andrew Douglas Pitonyak
Version: File size: 172.83 Kb
[ Home page ]
[ Editor review | Report broken link ]
Download rating details
Total votes: 0
Overall rating: 0
There are 12 unlogged users and 0 registered users online.
You can log-in or register for a user account here.