I posted this thread ealier, but perhaps my previous attachment is not clear.
I want to pull data from column E(Path) which is partly matched with cloumn A(item Number). Since there may have 2 or 3 matched result in column E. I need to pull each "Path" next to the corresponding Item Number (in column B,C and D) and remain empty if there has no match result.
Can someone give me a hand for my problem?
Thanks a lot
Last edited by dontdont; 11-24-2011 at 03:34 AM.
Hi dontdont
see this HELP(1).xlsx
Note: array formula is used and should be confirmed though Ctrl+Shift+Enter instead of Just Enter.
you should correctly mention the version of excel you are using. It will help to suggest you the most better solution. presently 2003 is mention in your profile.
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Thanks for your help. It seems working right now. (loading 30mins for 1% :-p) But you gave me a big help for this. Please allow me to say zillion thanks in chinese "萬分多謝您的協助" ^_^
Welcome, it is very pleasent to have thanks in chinese
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks