Search PARTIAL TEXT from range of cells and base on result replace data in a different cell.
CELL A1 to A4 contains data, cell B1 contains result.
A1=511AA
A2=521PT
A3=5341BR
A4=56601TT
If part of the text “BR” is present in any cell from range A1:A4, Cell B1 display X.
If part of the text “BR” is not present in any cell from range A1:A4, Cell B1 display y.
What is the formula for Cell B1?
Thanks.
Hi,
you could try
Please Login or Register to view this content.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks