Index/Match Help

JPFisher

Hi - I have a sheet called "Source Data" which has a list of roles in Column A and the description of the Role in Column B.

In another sheet "Worksuite Requests" I want the description from the Source Data to pull in if the role name is a match.

I can't quite get the formula:

Ric T

Hi @JPFisher,

You're close! Try this formula (you'll need to manually reference the bolded parts):

=INDEX({Source Date Deliverables}, MATCH([Role Onboarding For:]@row, {Source Data Role}, 0))

Note that for {Source Date Deliverables} and {Source Data Role}, recommend selecting the column header in your source data, so that the entire column is highlighted. Let me know if you have anymore questions!

Cheers,

Ric

Ric T

Hi @JPFisher,

You're close! Try this formula (you'll need to manually reference the bolded parts):

=INDEX({Source Date Deliverables}, MATCH([Role Onboarding For:]@row, {Source Data Role}, 0))

Note that for {Source Date Deliverables} and {Source Data Role}, recommend selecting the column header in your source data, so that the entire column is highlighted. Let me know if you have anymore questions!

Cheers,

Ric