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!!