OpenOffice Calc Lookup Tables

From Eugene Eric Kim

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.