Getting data from different columns in a same cell
Dear experts,
Greetings!!
This is my first post here. My query/requirement is, If you have a look at the attached sheet, the first sheet is the reference sheet containing client names and their listed products (current client list). In the second sheet, I want to look for various clients names and to provide an example I have added the client names for first molecule (Acetylsalicylic acid). Please note that the same molecule is listed for more than one client.
Kindly suggest.
Many thanks.
ok try in sheet Molecule list
C2Formula:
Please Login or Register to view this content.
Copy towards column N and down as well as
B2Formula:Please Login or Register to view this content.
Copy down.
Check the attached file.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thanks dear Ankur. I will use this in future.
Try this Macro
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks