Difference between revisions of "OpenOffice Calc Lookup Tables"
From Eugene Eric Kim
m (4 revisions: Importing pages from old eekim.com PurpleWiki (5th batch)) |
m (1 revision: Re-importing 5th batch) |
(No difference)
|
Revision as of 17:11, 20 May 2010
You can do lookup tables in OpenOffice Calc using a combination of the INDEX and MATCH functions. MATCH returns the position of a value in an array. INDEX returns the value of a position in an array.
"Basic Functions: INDEX, MATCH"
Also read about VLOOKUP.