Formula Assistance - VLOOPUP, COLLECT, INDEX???


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!