Find a certain sting in a column then return yes if found

[geliedee]

Hi All,

Is there any formula that we can use a formula where if a cell in column A contains the word N/A then it will say that Found and if not then blank?

[azumi]

Hi perhaps

=IF(A1="N/A","Found","")

[mick0005]

Try this. Since I haven't seen a sample of your data I am not 100% sure of all requirements. Note that this particular formula will result in an error if N/A was contained within a word, and it doesn't evaluate it for N/A on its own as a full word. I don't know if thats what you need or not.

Please Login or Register  to view this content.