Hi ,
Need help please .
I have two sheets .
Sheet A has the following :

user Designation Department Section TEAM
Amy A CFN OPS OPG
Tony B CGX ACC CSS
mariam D DAB GCC GMC
Jan A LDA GBS GXL
Jes X SAL AMS ACT
Ryan D SEL TRU BIM
Gran E MEL ATL MEX
Fred B MES ANL SUB

Sheet B has the following matrix
ASSIGN TO Designation Department Section TEAM
1 A CFN OPS OPG
2 B CGX ACC CSS
4 D DAB GCC GMC
4 A LDA GBS GXL
4 X SAL AMS ACT
8 D SEL TRU BIM
1 E MEL ATL MEX
3 B MES ANP SUB

What I want to do is
Compare every user data from sheet A to the matrix in sheet b and if matches all fields in a particular row ,return Assign to value from sheet B in another column ; if no match found then return “no matrix set”
Intention-Originally they might have been assigned to a different number ,now after comparison they wil be assigned new numbers.

Is this possible to achieve?
Thanks