Forum Discussion
How to validate multiple columns from a single duplicate column in 2 worksheets
I am looking to validate orders working from an external source sheet and an internal one, with both having only one column in them that match up.
Is there an easy way using vlookup to match the duplicates, but also pull other information in the rows (this info needs to be entered into the external sheet with other bits of info that cannot be pulled across the other way easily to the internal sheet so struggling to get my head around some sort of formula or multiple formulas to make this possible)
In the images I have highlighted in yellow the columns that are the same info and underlines in red the other columns I need to bring across to the external sheet from the internal sheet
Any help greatly appreciated. Sorry if makes no sense!
10 Replies
Is it possible to upload the actual spreadsheets (after taking out any confidential information, or modifying it so as to be anonymous).... images don't really convey the full reality.
And let us know if there are going to be not just duplicates in each (external and internal) sheet, but are there going to be multiple instances of those duplicates in some or many cases? This could be a simple situation, or it could be more complex, depending on things like that.
So a more compete description would be helpful, but at the very least a good representation of the actual spreadsheets involved.
Unless I'm missing something, the sample you sent has no Order Ref No's that match. So it's kind of difficult to create a test case. Now, I could obviously modify one or two so there is a match, but I have other questions anyway. So could I ask you to answer them and give a revised sample where the fundamental conditions are met in one or two cases, i.e., where there are matches between one or two Order Refs.
Once you find a match, you said you want the data in the green on the "Internal" sheet brought over to the "External"--that's easy enough to do when there's a match [see above], and we'd have to create columns for that, easy enough...
FINALLY, you make reference to a "Final Validation Sheet"--where is that? Is it just the to-be-updated External sheet, including your comments in the red columns? Or some other sheet altogether.
