Add/Replace data based on other data

[jiamec77]

Hi,

I'm not sure how to word this, so please bear with me.

Each month, I receive data for work with 10 columns and up to 19,000 lines. On the first report I received, I added an additional 2 columns at the end and painstakingly went through each line to add extra data I needed.

I have now received the new report and need to insert these columns, but making sure they match up to the correct rows. Meaning, row 10 on report 1 may not be the same person as row 10 on report 2.

I don't even know what terms to search for to determine how to do this!

Thanks in advance!!

 

[Rijnsent]

Hi Jiamec,
step 1 would be to find the unique identifier for each line. Say you have a unique ID in column B, you could use that. Assuming you added column K&L and your data starts at row 2 (row 1 being a header), get your new report and use VLOOKUP to get the values of the old report, using column B.

In the new report, this would be the formula for K2:
K2: =VLOOKUP(B2,'[Your old report file]Old sheet name'!$B$2:$L$19000,10,FALSE)

I made a lot of assumptions, but I hope this get you started.
Koen