Hi Experts,
I am using the following formula to find multiple values in a cell.
=SUMPRODUCT(--ISNUMBER(SEARCH({"#4","#5","#13","#44"},Y2)))>0
The problem is I am getting a False Match because it is finding TRUE values like #54, #55, #130 etc.
Is there a way to FIND the true value of what i am looking for
Any help would be great assistance
thanks Again for bailing me out....
I am using the following formula to find multiple values in a cell.
=SUMPRODUCT(--ISNUMBER(SEARCH({"#4","#5","#13","#44"},Y2)))>0
The problem is I am getting a False Match because it is finding TRUE values like #54, #55, #130 etc.
Is there a way to FIND the true value of what i am looking for
Any help would be great assistance
thanks Again for bailing me out....