Search text on entire sheet

[keith81591]

Hey, I am looking for a formula with will search a text to see if it is contained on another sheet, within the same workbook, regardless of the row or columnand return "Yes" or "NO" as a result. Is this possible?

[63falcondude]

Yes. Try COUNTIF.

COUNTIF will return the number of matches. You can then use the IF function to change the number to "Yes" or "NO".

If you would like more specific assistance, consider uploading a small representative sample workbook along with the desired results based on that sample.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"