Hi
I am looking for a formula which will give me an output of USER if part of the text in one cell matches part of the text in another.
A B C
smithm MIKE SMITH USER
As per the example above if part of the value in column A (say the first three or four letters) match any part of the value in column B I want an output of USER in column C
Maybe:
=IF(SUMPRODUCT(IFERROR(SEARCH(MID(A1,1,ROW(INDIRECT("3:"&LEN(A1)))),B1),""))>0,"USER" )
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks