Set lettercode(s) in a row based on check several rules registered in another sheet

[jmsla...@gmail.com]

Dear all,

Always nice to create a new wish :)
And hopely somebody want to help me out.

I have 2 sheets.

In Sheet.1 a lot of data in several columns.
In Sheet.2 a CodeList in Column A till F where;
A= For info only.
B= Code A till... last used row (A, B, C, D, ... etc..)
C= Column.C with data to check with Sheet.1 Column.U
D= Column.D with data to check with Sheet.1 Column.R
E= Column.E with data to check with Sheet.1 Column.O
F= Column.F with data to check with Sheet.1 Column.O

The macro must run in Sheet.1 Column.CA row 2 till last row.
For each row it must check;

If Sheet.2 Column.C IsNotEmpty; if Sheet.2 Column.C is identical with Sheet.1 Column.U
and
If Sheet.2 Column.D IsNotEmpty; if Sheet.2 Column.D is identical with Sheet.1 Column.R
and
If Sheet.2 Column.E IsNotEmpty; if Sheet.2 Column.E text is found in text Sheet.1 Column.O
and
If Sheet.2 Column.F IsNotEmpty; if Sheet.2 Column.F text is found in text Sheet.1 Column.O
Then
Code in the cell in Sheet.1 is Sheet.2 Column.B

So for each row in Sheet.1 this code should be run for each row in Sheet.2.
Based on this in for example Sheet.1 cell CA3 could result in ACDG because the data in Sheet.1 is matching with several rules in Sheet.2

To difficult for me :(

regards, Johan