mkpflorida
New Member
 Joined
 Nov 18, 2021
 Messages
 4
 Office Version

 2010
 Platform

 Windows
Hi Everyone:
I am brand new here and appreciate all the information here. I think I have an easy question, but cant seem to match an answer.
Here's my formula:
=SUMPRODUCT(ISNUMBER((SEARCH(indirect("REAL!$A$2:$A$7390"),A2))))
What I am trying to do is conditionally highlight based upon the formula above any cell that exact matches from a list in another sheet named "REAL", which has a list of items in column A from 1 to row 7390.
The problem is I am getting false positives because the above formula is not finding exacts, but also partials. Here's an example:
I want to find if "yellow banana" is in the other list on the "REAL" sheet, which it not. But "Red Banana" is. My current formula still highlights the cell in my other sheet because it finds the word "banana".
Hopefully that makes sense.
Hopefully someone can provide suggestions.
Thanks in advance!
Michael
I am brand new here and appreciate all the information here. I think I have an easy question, but cant seem to match an answer.
Here's my formula:
=SUMPRODUCT(ISNUMBER((SEARCH(indirect("REAL!$A$2:$A$7390"),A2))))
What I am trying to do is conditionally highlight based upon the formula above any cell that exact matches from a list in another sheet named "REAL", which has a list of items in column A from 1 to row 7390.
The problem is I am getting false positives because the above formula is not finding exacts, but also partials. Here's an example:
I want to find if "yellow banana" is in the other list on the "REAL" sheet, which it not. But "Red Banana" is. My current formula still highlights the cell in my other sheet because it finds the word "banana".
Hopefully that makes sense.
Hopefully someone can provide suggestions.
Thanks in advance!
Michael