Comparing data and updating spreadsheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
when you say update the User ID on sheet two, is there an existing number
which will be changed. if so, I would add a new column with the old IDs on
sheet two and add a new IDcolumn wit
=if(iserror(sumproduct(--(Sh1!Lastrange=last),--(Sh1!firstrange=first))),oldid,sumproduct(--(Sh1!Lastrange=last),--(Sh1!firstrange=first),Sh1!IDrange))
with the appropriate cells a
 
Whoops! What I want to do is update the UserID column in Spreadsheet B if the
names match and the UserID in Spreadsheet B is blank.
 
Trythe previous recommendation and changing the equation t
=if(and(oldid="",not(iserror(sumproduct(--(Sh1!Lastrange=last),--(Sh1!firstrange=first)))),sumproduct(--(Sh1!Lastrange=last),--(Sh1!firstrange=first),Sh1!IDrange),oldid)

I would add the step of copying the newid and paste special values over the
oldid range before new data is added to Sh1!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel spreadsheet compare 3
Appending Data from one spreadsheet to another 4
Compare and import data using two spreadsheets 1
Identify Duplicates that are not identical 4
How to compare and extract data in two columns 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Match 2 fields in 2 seperate Spreadsheets and fill another column 1
Compare spreadsheets & then extract data 2

Back
Top