Comparing data and updating spreadsheets
I have two spreadsheets with Last Name and First Name columns. What I would
like to do is compare the Last Name and First Name fields in Spreadsheet A to
the same fields in Spreadsheet B. If there's a match, I would like to take
the UserID from Spreadsheet A and update the UserID column in Spreadsheet B.
What is the easiest way to accomplish this?
|