Hi,

I am trying to use Index and Array formula to bring back multiple values by looking at a specific ID.

Sheet1- Has Two columns ( ID & Type)
Sheet 2 - Has two columns ( ID and Request ID)

Both sheets have the ID column that match, but an ID can have more than 1 "Type" and more than 1 "Request ID".

In a different sheet, I am calling it the Master sheet, I would like to bring back the "Type" & "Request ID" values that match the ID.

I have attached an example of a spreadsheet.

Test Workbook.xlsx


Thanks!