Find Match Between a Column Against Multiple Columns

[raykt]

I would like to find a match between Column C with multiple columns.

E.g. First digit of Column C against Column D and if there is a match, do nothing. If there isn't, highlight a next row value of respective column.

@ Column A , I have compare cell by cell value. Please suggest me how to make it in one formula or func.

[FDibbins]

A few observations...

1. You dont need to include TRUE/FALSE in this formula, in fact, you dont even need the IF() statement...
=IF(LEFT(C3,1)=D3,TRUE,FALSE)
You can just use...
=LEFT(C3,1)=D3

2. what exactly are you trying to find? If you have included sample answers there, I cannot see them
3. Some of your numbers are actually text that just looks like a number (look for the small green triangle in the cells)

Maybe try this, copied down?
=MATCH(--LEFT(C3,1),D3:M3,0)

[raykt]

Actually Column A is just for testing purpose. Ideal outcome is, insert a value in Column C(will always be 2digits).

Would like to match between 1st digit of Column C vs ColumnD.

e.g

Column C:3 vs D:3 ( 9 : 3 )
C:4 vs D:4 ( 6 : 0 )
C:5 vs D:5 ( 5 : 5 )
so on.

As long there is a return of matching from the comparison, will do nothing.

I have manually compared 1 digit of Column C with D,E,F,G,.. ,and only with G column, there isn't any match, so I would like to get the value of Column G's next row value(highlighted 8 D24).

[raykt]

forgot to say. The comparison will happen automatically after entering the value in C column.