Not certain how to word this so it makes sense, but I'll give it my best shot.
I need to figure out how to do a lookup or index function when there is a 1:many relationship when returning the value.
I've attached an example workbook to this post. I need show in cell F2 that the number 1 corresponds to the results from cells B2:B9. Ideally, I'd like cell F2 to show something like "A,B,C,D,E,F,G"
Can anyone show me how?
Maybe with an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Refer attached workbook for the output.
See if the below UDF helps fulfill your need.
Usage: In F2, use this User-Defined Function as
Please Login or Register to view this content.Formula:
Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks