Link Spreadsheets - Merge Data

I have two spreadsheets with similar data (Last Name, First Name, User ID). One spreadsheet has the two name fields separated into two columns, while the other has them combined into one (Lastname, Firstname). The first spreadsheet doesn't have the UserID field populated. I need to compare the records between the two spreadsheets and update the UserID from SS2 to SS1 where a match is found.

• How do I link the two spreadsheets?
• How do I perform the comparison between the first and last name fields, being that they are record in two columns in SS1 and a single column in SS2?
• When a match is found between spreadsheets, how do I copy the UserID from SS2 to SS1?

I have not scripted Excel before, so this is a totally foreign task for me. Thanks.

Hi,

Take a look at the Vlookup() function in Help ...F1
It should fix your problem ...

HTH
Carim

This looks like a great place to start, if I can figure out how to perform it between two different spreadsheets. However, it doesn't clear the hurdle of comparing names found in one column in SS2 and two columns in SS1.

Thanks. I was acutally toying with combining the two column into one, and then doing a comparison: =CONCATENATE(A1,", ",B1).

I think I may need to copy the worksheet of SS2 into SS1 so I can do the VLOOKUP.

In my formula, can I combine functions to have the conatenation and the VLOOKUP in the same string?