OpenOffice Calc Lookup Tables

From Eugene Eric Kim
Revision as of 17:09, 20 May 2010 by Eekim (talk | contribs) (4 revisions: Importing pages from old eekim.com PurpleWiki (5th batch))

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=1362"