Hello everyone, first time poster and rookie excel user.
I am trying to create either a vlookup formula or a index match formula to match a specific id number with a corresponding location code stored on a separate worksheet within the same workbook, however each unique id may have one or more locations associated with it and it may also have multiples of the same location numbers associated with it. I would like the workbook to return all values in adjacent cells. Is there a way to do that? I have attempted searches and following previous directions but I have been unable to make it work.
I am attaching a sample workbook with the data
I am hoping to have results display in columns G, H, I, ect on the "Match Sheet" based on how many different locations are associated with the specific ID number from the "Data Sheet"
for example person Id 16209 should return two different location codes, 407 and 210 from the "data sheet" while personid 16284 should return two of the same location codes, 457 and 457
any help would be greatly appreciated the boss handed this off to me and it seems a bit over my head at the time
Thank you all in advance.