finding a text string and returning a Y or N

[wilksy]

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)

[arthurbr]

Hi and welcome to the board

Try

Please Login or Register  to view this content.

Be aware the FIND is case sensitive, if necessary use the SEARCH function instead

[zbor]

FIND will return you "N/A if ti doesn't find it.

therefore you need to do next:

check ISNA() result of your formula

=IF(ISNA(FIND("B19",D5)), "N","Y")

[wilksy]

Thanks for the welcome and thanks for the answer, sometimes you just can't see the wood for the trees.

Regards

martyn