Formula Assistance - VLOOPUP, COLLECT, INDEX???

Angela Logie

I have a survey intake sheet that contains Project Managers and Type i.e. Managed Services / Professional Services

I'm trying to create another sheet that automatically pulls in the below info from the intake sheet:

And don't know if I should be using a VLOOKUP, INDEX, COLLECT

I need the formula to be able to add the Project Managers names, i.e. if there are new PMs added at the Intake sheet and not have to manually add the PMs to the above sheet to do a match to.

Hope this makes sense

Thanks in advance

Angela Logie

Actually the numbers will be from an AVG column on the Intake sheet, not a count