Excel Spreadsheet

TrayC1201 
You can use VLOOKUP or INDEX and MATCH functions.
VLOOKUP method:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

•  lookup_value: The value you want to look for in the second spreadsheet.
• table_array: The range of cells in the second spreadsheet where the lookup value is located.
• col_index_num: The column number in the table_array from which the matching value must be returned.
• range_lookup: A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.

If your lookup_value is in the A column of Spreadsheet 2 and the data you want to pull into Spreadsheet 1 is in the B column, you would use col_index_num (2). If you want an exact match, use FALSE for range_lookup.

=VLOOKUP(A2, 'Spreadsheet2'!A:B, 2, FALSE)

INDEX and MATCH method:

=INDEX(column_to_return_a_value_from, MATCH(lookup_value, column_to_lookup_the_value_in, 0))

• column_to_return_a_value_from: The column in Spreadsheet 2 from which you want to pull the data into Spreadsheet 1.
• lookup_value: The value you want to look for in Spreadsheet 2.
• column_to_lookup_the_value_in: The column in Spreadsheet 2 where Excel should look for the lookup_value.

The MATCH function returns the position of the lookup_value in column_to_lookup_the_value_in, and the INDEX function uses that position to return the value from the same position in column_to_return_a_value_from.

=INDEX('Spreadsheet2'!B:B, MATCH(A2, 'Spreadsheet2'!A:A, 0))

This formula will look for the value in cell A2 of Spreadsheet 1 in column A of Spreadsheet 2 and return the corresponding value from column B of Spreadsheet 2.