Hi,
Request for vba code with loops for the below :
I have list of names in column E and full names in column I
And i need to match list of column E with list of column I
If matched column I values should be pasted in column F against the value matched in column I.
Sample Image :
Partial String Match.png
Sample workbook attached......
Can anyone please...
Thank You.
This code is not case sensitive.
jagadeesh will match jagadeesh rt or Jagadeesh rt.
If you want it to be case sensitive then change this line.
to this
Please Login or Register to view this content.
Good Luck.Please Login or Register to view this content.
If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.
If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Hello jagadeesh.rt,
You can use this formula in column "F" and drag down.=INDEX($I:$I,MATCH("*"&E2&"*",$I:$I,0))
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks