Use the VLOOKUP (for values arranged in columns) or HLOOKUP (for values arranged in rows) function to extract information. You can use functions for data exportation within the same spreadsheet or from one file to another. However, it's important to note that both VLOOKUP and HLOOKUP have limitations and can be complex to use with large data sets or when looking for more dynamic lookups.