The link below is a generic workbook using the excellent code Claus has been so helpful with.

In essence a six digit "item" is derived from six drop down values and the code looks up that "item" on sheet3 and returns stuff offset to both the right and left of the lookup column F back to sheet 1 into the gray shaded area.

Hence, it builds a list of the lookup "item" and its components in the gray area.

If there is no match for the "item" as it looks in column F of sheet 3, then there is a msgbox pop up "No Match".

Here is where I am wondering about the feasibility of identifying which one of the digits in "item" is causing the No Match.

The workbook as it is sheet 1 shows 1 2 3 4 5 6 as "item". (note the 6 is shaded). On sheet 3 see the same color shade entry in column F and you will see that entry is 1 2 3 4 5 7. This of course causes a No Match alert.
(And I used the very first entry to make it easy to demo)

Is there an easy way to notify the user that the number 6 is causing the mismatch? If the alert said "No match, component 6 does not match" that would great. But is it feasible?

I know this is where the mismatch is because I set it up as a demo for this post. I'm thinking things will get real sticky when as a user you pick components for an item and get a No Match, you don't know which component is causing the No Match.

https://www.dropbox.com/s/dgy83hwqa4...rop%20Box.xlsm

Regards,
Howard