Find Specific Trailing Letters and Return Message

[Cleman04]

All,

I would like to have a cell (in my attached spreadsheet the cell is B10) post a reminder to me in text ("Ask for 2008 for serial 'A' also") whenever any of the serial numbers in the column above it (in my attached spreadsheet the cells are B2:B8) end with either a "B" or a "C" at the end of them. If none of the cells B2:B8 end with either a "B" or a "C" at the end of them I would like the cell to remain blank.

I made an attempt at a formula but clearly have not gotten it right yet. I would guess this is pretty simplistic for some of you, so thank you for your patience and for your assistance,

Cory

Please see my attached spreadsheet.

[NBVC]

Try:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"B","C"},B2:B8))),"Ask for 2008 for serial 'A' also","")