Forum Discussion
How to validate multiple columns from a single duplicate column in 2 worksheets
mathetes I have attached a small example sheet with random info to see if that helps?
Its just understanding the step by step as every time I try something I just get errors, so I must be doing something wrong or missing something out. Many thanks for your response.
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.
mathetes ok I will try explain a bit better. I have added a new sheet with better representation.
Ill explain each highlighted part.
The final sheet needs to be the EXTERNAL sheet.
Yellow - Find the duplicates from INTERNAL & EXTERNAL in these columns.
Green - These values also need pulling across with the web order number into EXTERNAL.
Red - Once the information from INTERNAL has been moved to EXTERNAL these are the columns I will then be able to fill in and use this sheet as the final validation sheet.
The reason why I need to do it this way around is the columns in the EXTERNAL sheet are important to be included in the final validation.
I hope I have explained it a little better. Many thanks!
Here you go. I used VLOOKUP. It looks as if EVERY code in the External sheet IS matched by one in the INTERNAL, so there's data to be brought over in every case. Is that in fact what you expected?