dear experts
i need formula to find the cell values would be appropriate match with key words list
I Have partner name list next column i want result whether the partner where ever reflect in keywords list as nearest values
if partner name is almost nearest value to the list of keys then result with partner name like YES EXIST AS "Aegis Infoware Pvt. Ltd"
find the attachment
In B2 Cell
=IF(SUMPRODUCT(COUNTIF(A2,"*"&$D$2:$D$14&"*")),"YES EXIST AS "&A2,"")
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
VBA code as option.
Last edited by AB33; 11-09-2013 at 10:16 AM.
Dude AB33 the code gets result for all values as same as out of keys box...
Corrected, See post no3
Perfect Master Piece of Work Guys Thanks to AB33 and Sixthsense..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks