Hi, I am having a little difficulty in writing a formula to find a text (and number)in a cell and returning a Y or N.

I have in column A for instance either B19 or HAAC or BRSC what I am trying to do is interogate column A to see if any of the cells contain B19 and if so return a Y if not then return a N.

I can get a formula to give a Y but it gives a #VALUE if it does not contain B19.

The formula I am using is =IF(FIND("B19",D5),"Y"," ") D5 is the column and row.

Where am I going wrong!

Regards

Martyn

PS B19 is not a cell reference but is the text/number in the cell (it is the name of my motor club)