Need help with an index/match formula

Jaz693

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:

Kelly Moore

Hey @Jaz693

Try this

=IF(COUNTIFS(({2024 ERM Roadmap - Name},[Team Member]@row)>0,"Core", "Extended")

Will this work for you?

Kelly

Jaz693

not really. I tried, and I get unparseable now.

Jaz693

But I just found the issue. Extra parenthesis. It seems to work now.

Jaz693

Thank you!