Hi JBeaucaire

Thanks for your help

Im not sure which part you are not so clear in the second part

To make it simple

Pls look at the below

Sheet 1
Matrix
A1 B1
No Vno
001 590
001 998
001 999
002 1000
002 1001
002 1002
003 2000
003 2001
003 2002


Sheet 2
Report
A1 B1 C1
No Vno Result
002 2001 Bad
001 2002 Bad
001 2003 Bad
002 1000 Good
002 1010 Bad
002 1002 Good
003 590 Bad
001 998 Good
003 999 Bad



so im not sure how i validate these kind of checks and display the result in c1.