Index/Match Error

Hello-

I'm trying to use INDEX and Match in lieu of vlookup. my formula is:

=INDEX({V.9 IP Fit Test Results Range 3}, MATCH(EID@row , {V.9 IP Fit Test Results Range 4}), 0)

but it's populating a lot of my cells with the same date even though some of them should be dated a month earlier if i manually do a search on the source sheet. what am i doing wrong?

Find more posts tagged with

Accepted answers

All comments

Cassie L

@kbegin Forgive the question, do any duplicate EIDs exist in your dataset? That could be a reason that your formula would return dates you do not expect.

If I break down your formula, you have

Formula looks for the EID at current row
Formula then search for that EID in Range 4
Once the correct row is identified, the formula should return the value from Range 3 at the identified row.

Therefore, if your EIDs are duplicated in any way, it could be searching in one spot and not the other, etc.

I also would recommend to double check that the referenced Ranges are mapped properly (sanity check if you will)

Hard to know for sure without seeing the data but I hope this helps!

Best,

Cassie

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.