Use the VLOOKUP (for values arranged in columns) or HLOOKUP (for values arranged in rows) function to extract information. The functions can be used for data exportation within the same spreadsheet or even from one file to another.