Working with data betwen two sheets and mutliple columns
Good Morning All,
I am having with an issue matchhing data between two sheets based on certain criteria.
1st sheet is a list of form responses. I have a name of requestor column. I need to complete two objectives based on this requestor.
- See if their name exists in one of two columns on another sheet.
- 2 if their name exists provide the name of their matching supervisor.
Every formula i have tried comes back #unparsable.
Column Name on 1st Sheet - Name of Requstor:
Column Names on 2nd Sheet - Approvers - Custodians
Help Article Resources
Check out the Formula Handbook template!