Need to look up a value and return multiple values-INDEX/MATCH?

Hi all, I have been searching to answer to this specific issue, and I see a lot about the INDEX and MATCH functions. I can't seem to figure out how to adapt the info I've read in other posts to my situation.

I have two worksheets. The first, named TITLES, has an ID# and a title. The second, named AKAs, has an ID# and and AKA TITLE. I want to look up the ID# from TITLES and return the multiple values from AKAs. The desired result could be whichever of the 3 examples is easier- repeating the TITLE for each AKA TITLE, or grouping the AKA TITLES under one TITLE, or concatenating the AKA TITLES into one cell.

Any assistance would be greatly appreciated. Thank you!!

I am also facing the same problem, can anyone tell me how can I get the Desired Result Option 3 (as attached sheet of abigail99)

Thx

Originally Posted by kbkumar

Hi - If you use the below in cell C2 of AKA TITLES sheet, does it work for you?

Formula:

Please Login or Register  to view this content.

You can then sort on ID#.

kbkumar, thanks for taking a look. The problem is that your solution gives me the TITLES to match the AKA TITLES. I need the other way around. The AKA TITLES list is going to have many thousands of rows and be fairly static, and each week I'm going to get a new list of 100 or so TITLES, which need to be matched with AKA TITLES.

static data