Difference between revisions of "OpenOffice Calc Lookup Tables"
From Eugene Eric Kim
(Converted from PurpleWiki) |
m (8 revisions imported: Imported from WebFaction on September 13, 2021 with Interwiki prefix Eekim) |
(One intermediate revision by the same user not shown) | |
(No difference)
|
Latest revision as of 19:32, 13 September 2021
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.