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
