Hi im looking for formula to search 2 cells,find partial match and return cell value.
Where the word "new" is found.
A1 = new blue shorts
A2 = blue jeans
So B1 would return the cell content of A1, answer new shorts
Thanks
Hi im looking for formula to search 2 cells,find partial match and return cell value.
Where the word "new" is found.
A1 = new blue shorts
A2 = blue jeans
So B1 would return the cell content of A1, answer new shorts
Thanks
Formula:Please Login or Register to view this content.
Try in B1
Punnam
ste33uk ,
A sample sheet with results manually will be easy, kindly check the yellow banner on top.
Punnam
Have attached book
ste33uk ,
I am sorry, hope someone else could help from here.
Punnam
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks