Difference between revisions of "OpenOffice Calc Lookup Tables"
From Eugene Eric Kim
Eekim>Adsl-71-146-135-205.dsl.pltn13.sbcglobal.net |
Eekim>Adsl-71-146-135-205.dsl.pltn13.sbcglobal.net |
||
Line 2: | Line 2: | ||
[http://www.openofficetips.com/blog/archives/2004/11/basic_functions_4.html "Basic Functions: INDEX, MATCH"] {nid MK0} | [http://www.openofficetips.com/blog/archives/2004/11/basic_functions_4.html "Basic Functions: INDEX, MATCH"] {nid MK0} | ||
Also see [http://www.openofficetips.com/category/function-tips/page/2/ "VLOOKUP."] {nid MK1} |
Revision as of 19:52, 5 September 2007
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. {nid MJZ}
"Basic Functions: INDEX, MATCH" {nid MK0}
Also see "VLOOKUP." {nid MK1}