OpenOffice Calc Lookup Tables

From Eugene Eric Kim

Revision as of 19:32, 13 September 2021 by Eekim (talk | contribs) (8 revisions imported: Imported from WebFaction on September 13, 2021 with Interwiki prefix Eekim)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

Retrieved from "https://wiki.eekim.com/w/index.php?title=OpenOffice_Calc_Lookup_Tables&oldid=1367"