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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks