partialy search text from list and then past in same worksheet
Hey guys I have a excel sheet of around 3 thousands of record, actually i want to search partially text from one list in same worksheet and then copy corresponding part number of that text, text can be partially search example excel sheet attached. please help me for prepare this formula i am not sure but may be lookup or any other formula whatever suitable for this purpose.
worksheet link
https://www.dropbox.com/s/k5n0onqa98...heet.xlsx?dl=0
Last edited by mirza5313; 05-04-2016 at 01:55 PM.
Hi
You can try the below formula
But for this formula to work properly, 2 constraints
Please Login or Register to view this content.
* Column A & Column B should be replaced as vice versa I mean Column values should be like this Column A - Item, Column B - Part Number
* First Word of the text in D column should be present in Item
Thanks & Regards,
Vidhya
Last edited by vidhyakrr; 05-01-2016 at 08:20 PM.
Hi Vidhya, Thanks for your formula, but unfortunately this formula seems not working this not retrieve part number from column A to c, also I really need to search partial text means if we put item Cover Pillow instead of Pillow cover then formula should be able to retrieve part number and also highlight text at column A.
Hopefully you understand and I really appreciate for your help and interest.
Kindest regards,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks