"Check every cell in C3 and down till last data with every cells in A3 till end of A col with data, if match found then, match the values in col D3 onwards with B3 and down till end.If no match found, then color with reference color of D1 cell.
Example:-
in C3 is ""B"", i match with col A, found ""B"". now for ""B""s in col C we have values (2,3) but in col A for ""B""s are values (9,5). so colored the values 2 and 3 in col D.
pls note: my result be on D col only.
and every data in each columns are variable not fixed." "Check every cell in C3 and down till last data with every cells in A3 till end of A col with data, if match found then, match the values in col D3 onwards with B3 and down till end.If no match found, then color with reference color of D1 cell.
Example:-
in C3 is ""B"", i match with col A, found ""B"". now for ""B""s in col C we have values (2,3) but in col A for ""B""s are values (9,5). so colored the values 2 and 3 in col D.
pls note: my result be on D col only.
and every data in each columns are variable not fixed."
Check1 Result1 Check2 Result2 Check1 Result1 Check2 Result2
A 32 B 2 A 32 B 2
A 3 B 3 A 3 B 3
A 8 C 9 A 8 C 9
B 9 C 25 r B 9 C 25
B 5 C 26 e B 5 C 26
B 0 F VV s B 0 F VV
K 9 F 9 u K 9 F 9
K VV L 25 l K VV L 25
K 60 L 0 t K 60 L 0
K 12 L 1 K 12 L 1
D 15 P 12 D 15 P 12
D 30 P 16 D 30 P 16
F 11 K VV F 11 K VV
H 100 K 81 H 100 K 81
C ZZ A 32 C ZZ A 32
C 9 E 61 C 9 E 61
C 19 A 98 C 19 A 98
C 23 C 23
C 25 C 25