Index Match not returning desired value

Hello, I am trying to pull information from one sheet into another using a "Dept ID" as the key. I've done this several times but for some reason, the formula is returning data from the wrong columns, and I can't figure out what is wrong.

Current Formula: =INDEX({Department Operations Portfolio}, MATCH($[Dept ID]@row, {Dept ID}, 0), MATCH(Name$1, {Department Operations Header Row}, 0))

Department Operations Sheet

Project Data Sheet - Where the formula is. Notice it's pulling the 'Sponsor' input into the 'Name' column.

Thanks for any help you can provide!

Find more posts tagged with

Accepted answers

Paul Newcome

Double check your ranges. The {Header} should only cover the columns selected in the {Portfolio} range.

All comments

Paul Newcome

Double check your ranges. The {Header} should only cover the columns selected in the {Portfolio} range.

Nichole Pyle

That worked, thank you very much!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.