How do I write a formula similar to a lookup in Excel?


I would like to populate a field in the Summary of a sheet with a contact name from another sheet. I am looking for help to write a formula that will say:

Find the row where the words 'Project 25' is in a Column titled Project Name, in Sheet 'All Projects' and return the text in the column of the same row titled "Manager"

I have been given: =IFERROR(INDEX(COLLECT({Program Owner}, {Opportunity Number}, [Parent Opportunity Number]#), 1), "<<PROGRAM OWNER>>") which works to bring back the Program Owner but when I replace the word Program Owner with Manager, it doesn't work.

Any help would be greatly appreciated.



Best Answer