craigexcel
Active Member
- Joined
- Jun 28, 2006
- Messages
- 298
- Office Version
- 2016
- Platform
- Windows
I had to copy a worksheet from my working file (workbook), as its own single-sheet workbook, so a coworker could work on that data independently. (Not my choice, but what was required. 
)
So now, that stand-alone worksheet has updated values in it, but the worksheet it was copied from does not ... and needs to be updated, so it can have the correct updated values.
Between the 2 worksheets, I want to find where Columns A & B are a match (by record / row), and then return, by formula, in the primary workbook, those values from the stand-alone worksheet for the other fields for each record (Columns C-W).
The data in the standalone worksheet has been reordered, and not sure how, but they're defintely not in the same order as when I sent the file originally.
Would greatly appreciate your suggestions for how to approach this one. Thanks!
edit: I have been searching for a couple of days on this, but I have only been able to find references to matching 1 column with another column, not matching 2 columns between 2 worksheets.
)So now, that stand-alone worksheet has updated values in it, but the worksheet it was copied from does not ... and needs to be updated, so it can have the correct updated values.
Between the 2 worksheets, I want to find where Columns A & B are a match (by record / row), and then return, by formula, in the primary workbook, those values from the stand-alone worksheet for the other fields for each record (Columns C-W).
The data in the standalone worksheet has been reordered, and not sure how, but they're defintely not in the same order as when I sent the file originally.
Would greatly appreciate your suggestions for how to approach this one. Thanks!
edit: I have been searching for a couple of days on this, but I have only been able to find references to matching 1 column with another column, not matching 2 columns between 2 worksheets.
Last edited:
