Hi I have a string in a column and the last two digits are going to decide
which value is going to appear in another cell.

EG -
YTR567TT
YTR567VT
YTR567CT

Because the first ends in T* I want to call this a 1, the second is V* and
this will be 2 and the last is C* and this should be 3.

How do I conditionally fill the cell with 1, 2 or 3?

I want to make it so it is carried on as a trend down the page too.

Thanks in advance.