Hi All,
I have the tile in column A, and I have keywords mentioned them in column E. Here I need to update the keyword which is contains the exact keyword which I had mentioned. Please check my attachment file for better understanding.
Hi All,
I have the tile in column A, and I have keywords mentioned them in column E. Here I need to update the keyword which is contains the exact keyword which I had mentioned. Please check my attachment file for better understanding.
maybe this !!!
B2=IFERROR(LOOKUP(2,1/(MAX(INDEX(ISNUMBER(SEARCH(E$2:E$8,A2))*LEN(E$2:E$8),0))=(SEARCH(E$2:E$8,A2)>0)*LEN(E$2:E$8)),E$2:E$8),"")
Try the above, copy and paste towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
maybe THIS?
row H or row I
Another Option...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks