OpenOffice Calc Lookup Tables

From Eugene Eric Kim
Revision as of 17:11, 20 May 2010 by Eekim (talk | contribs) (1 revision: Re-importing 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=1363"