bluefish44
Board Regular
- Joined
- Apr 3, 2009
- Messages
- 190
Hi All and Thanks in Advance for your help.
I have the following formula which is working as expected...It gives a TRUE or FALSE as to whether a string in cell b6 is contained in a list of cells (J2:J26).
Instead of the TRUE/FALSE, I am hoping for the formula to return the Actual value in cells J2:J26 that it found in B6 causing the result to be true.
SUMPRODUCT(--ISNUMBER(SEARCH($J$2:$J$26,B6)))>0
I have the following formula which is working as expected...It gives a TRUE or FALSE as to whether a string in cell b6 is contained in a list of cells (J2:J26).
Instead of the TRUE/FALSE, I am hoping for the formula to return the Actual value in cells J2:J26 that it found in B6 causing the result to be true.
SUMPRODUCT(--ISNUMBER(SEARCH($J$2:$J$26,B6)))>0