Formula help - looking at last two letters in multi-letter text string in single

[tim]

I am looking for a function that will allow me to search
or incorportate values into a formula based on the last
two letters of a word or text symbol contained in a cell.

For example if the text reads "IBMJK" I need to search
based on the value of the last two letters "JK" The last
two letters represent a month and dollar value. There
will always be between 2 and 4 letters in front of
the "last two letters" (total letters between 4 & 6).

How can I search/ find or inclued in an "if/then" function
the ability to look at the only the last two letters of a
text string, which is located in a single cell?

The last two letters represent a month and dollar value
respectively. I need to search and identify/highlight all
cells containing symbols for specific months and then
include those values in another formula.

The cells containing the text values are arranged in a
single column.

 

[Jason Morin]

If your strings are in col. A and the text to search for
is in F1, try:

=IF(ISNUMBER(SEARCH(RIGHT($F$1,2),A1)),1,"")

in an open col. and fill down. All rows with a 1 mean the
string in col. A contains the last 2 characters of the
string in F1.

HTH
Jason
Atlanta, GA

 

[Bob Umlas]

=IF(RIGHT(a1,2)="JK",...,...)