Please help

There are 2 excel issues which im working on

The first part which i had is like matching unique descriptions to unique nos.

Actualy there will be a matrix which has the no and name.

Daily i pull out a report from an application and match that report with the matrix to ensure that the data in the application matches with the matrix

For example

Matrix
No Name
23 Vendor 1
45 Vendor 2
78 Vendor 3
80 Vendor 5



Report

No Name
23 Vendor 5 Bad
45 Vendor 1 Bad
78 Vendor 3 Good
80 Vendor 1 Bad

This is the validation im trying to implement. The matrix should be the source for this validation.


The second part which i have added is like the below

its a seperate/different kind of match validation.

Matrix

No Vno
001 590
001 998
001 999
002 1000


Report
Report
No Vno
001 1000 Bad
001 1001 Bad
001 1005 Bad


so here its a different scenario a unique no will have more than one Vno.

So i need to check that kind of a validation here.

The matrix should be the source for this validation as well.