I have 2 spreadsheets, Spreadsheet 1 with names and contact information, and SS 2 with contact information and an ID number. Names are in Column I on SS1 and Column B on SS2. The ID numbers are in Column A on SS 2.
I need to take the ID numbers from SS 2 and match them up with the right names on SS1.
I am sure there is a way to do this with vlookup, but after researching and trying to learn it, I just can't figure it out.