1 Select a Master Roster
2 The Master Table (Source Data)
Note the ID in the first column to look up values later.
3 Retrieve Specific Data
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Data Practice Lab
Note the ID in the first column to look up values later.