12-20-2015, 06:01 AM
|
|
Novice
|
|
Join Date: Dec 2015
Posts: 12
|
|
Hi Charles,
My code does:
- Concatenates the first 6 columns in Sheet2-G
- Compare all rows in Sheets1 to rows in Sheet2 (rows can have different order in the two sheets).
- If rows match for every values then you have the " V " in sheet 1 for the matched row.(those rows are correct, Checked!)
- When there is no entire match, so for the row in sheets that don't have the " V", the INDEX/MATCH formula in sheet1-H looks for the same combination "vendor/plant/part number" in sheets 2 and when found it reports the concatenation you have in sheet2-G for the row that match the combo "vendor/plant/part number".
- That way I can easily compare the concatenation with the row in sheet1 to see why they don't match.
Thanks
|
Similar Threads
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)
Windows 7 64bit 
Office 2010 64bit
Threaded Mode