Lookup that returns multiple results

[paulaqq]

I have a tracking spreadsheet that we use to make notes about our progress on a particular contract. Separately, we have a SharePoint workflow with about 8 approvals related to the same contract numbers. I periodically need to look up all of the open workflows and identify the names of the people on that list in our tracking sheet. I can download a list of the open workflows in Excel, and I can copy it into a separate tab on our tracker workbook. I've seen a few responses on this and other forums providing equations using nested functions of IFERROR, ROWS, INDEX, SMALL, OFFSET, and other functions I don't understand very well. When I try to substitute my references and ranges into those equations, I can't get them to work. I've made a sample workbook, attached. The data in red font on the tracker tab is what I am trying to pull from the OpenTasks tab. I can work with a solution that pulls names into separate cells on the tracker sheet, because I can concatenate them. Any help on identifying an equation I can use is greatly appreciated.

[Bo_Ry]

Please try at
Open task C2
=IFERROR(B2&", "&VLOOKUP(A2,A3:C9,3,0),B2)

Tracker B2
=VLOOKUP(A2,OpenTasks!$A$2:$C$9,3,0)

[paulaqq]

I thought I understood VLOOKUP, but apparently I have more to learn. This is so simple! Thank you so much!