Difference between revisions of "OpenOffice Calc Lookup Tables"
From Eugene Eric Kim
Eekim>Adsl-71-146-135-205.dsl.pltn13.sbcglobal.net |
m (8 revisions imported: Imported from WebFaction on September 13, 2021 with Interwiki prefix Eekim) |
||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
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. | 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. | ||
[http://www.openofficetips.com/blog/archives/2004/11/basic_functions_4.html "Basic Functions: INDEX, MATCH"] | [http://www.openofficetips.com/blog/archives/2004/11/basic_functions_4.html "Basic Functions: INDEX, MATCH"] | ||
Also read about [http://www.openofficetips.com/2005/04/06/looking-up-data-in-tables-v/ VLOOKUP]. | Also read about [http://www.openofficetips.com/2005/04/06/looking-up-data-in-tables-v/ VLOOKUP]. |
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.