Index Formula Using Multiple Criteria

I'm trying to create an index formula that matches two different columns in a separate sheet but I keep getting #INVALIDVALUE. What am I doing wrong?

=INDEX({02 - Pre-Con Tracker PRECON DATES}, MATCH(Comm@row, {02 - Pre-Con Tracker COMM}), MATCH(Lot@row, {02 - Pre-Con Tracker LOT NUMBER}))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide screenshots for context? How many columns does your first range cover? Are you trying to match on two separate columns or pull from two separate columns?

Lacey C

Paul,

I'm trying to match two separate columns.

I'm trying to pull the "Scheduled Date" into another sheet. But I need to match the "Comm" and "Lot" columns as well.

Lacey C

trying to add the precon date to this sheet, Paul.

Lacey C

@paulnewcome see above

Paul Newcome

In that case you will need an INDEX/COLLECT instead.

=INDEX(COLLECT({02 - Pre-Con Tracker PRECON DATES}, {02 - Pre-Con Tracker COMM}, Comm@row, {02 - Pre-Con Tracker LOT NUMBER}, Lot@row), 1)

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.