If statements - but need to look up value of part of the text in a particular cell

[Anvo]

Column A Column B
ABC.1AA AA
EFG.XBB BB
HIJ.UCC CC
KLM.1AA AA
jhde.XBB BB
tyjss.UCC CC


I am using the formula: =IF(A2=".1AA",AA,(If (A2=".XBB","BB",If(A2=".UCC","CC",0))))
How do I make it look at the last 3 or 4 characters and return a specific value if true ?

I appreciate the help and support.

[6StringJazzer]

This formula will look for a match of the last four characters in the cells:

Please Login or Register  to view this content.

With this particular data sample you would get the same result with

Please Login or Register  to view this content.

but maybe the data is not realistic.

[Richard Buttrey]

Which is it, the last 3 or the last 4? Do you mean any characters after the dot.
Is column B the result you want or another set of data which isn't in use here.

In any case this is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

[Anvo]

This is what I was looking for ! - thank you very much .
I appreciate the help.