Need help with an index/match formula
I have two sheets.
A project plan sheet with contacts in the assigned column, then another sheet called Team member that lists the team Member name along with their departments. On the Team member sheet, I want the column to auto populate with either Core or extended depending on if their name displays anywhere in the assigned column on the project. If their name is present, then should display core, otherwise Extended.
My current formula on the team member list displays an invalid data type error: =IF(INDEX({2024 ERM Roadmap - Name}, MATCH([Team Member]@row, {2024 ERM Roadmap - Name}, 0)), "Core", "Extended")
{2024 ERM Roadmap - Name} = is the range on the project plan. Any ideas on how to get it to work?
Project Plan:
Team Member Sheet:
Answers
-
Hey @Jaz693
Try this
=IF(COUNTIFS(({2024 ERM Roadmap - Name},[Team Member]@row)>0,"Core", "Extended")
Will this work for you?
Kelly
-
not really. I tried, and I get unparseable now.
-
But I just found the issue. Extra parenthesis. It seems to work now.
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!