I have an issue which i almost have solved with one hiccup.

I have a cell of information that looks like: A1; A4; C6; H9
It's just text. I then have a series of columns that looks to see if A1, A2, A3 etc is in that original cell.

=IF(ISNUMBER(SEARCH(F$1,Main!$AY9)),"L","")

This is basically the formula I used. It searches AY9 in "Main" to see if the contents in F1 are in that cell. Works great.

The problem comes if the info is: A1; A6; C12

The column for C1 and C12 are both triggered and the "L" will be in both columns. And I would only want it in C12. I thought about doing another search where if the cell contains C12 then don't put the L in C1, but the cell might: A1; H3; C1; C12 and then I would want it in both cells.

Is there a way I can differentiate between C1 and C12 with some formula?

Thanks.