Index Match Error

Are you able to help me with a formula problem?

I am using a combination of MID and Right functions to pull a number from a text string....

Manager Name = Karri (800014723)

Manager ID =MID(RIGHT([Manager Name]@row, 11), 2, 9)

Manager ID = 800014723

--------------------------------

Now I am trying to use the Manager ID cell where 800014723 was returned in an index/ match formula. I keep getting the match not found error. But if I put 800014723 in as simple text in a cell, it works and returns the correct value.

=IFERROR(INDEX({Staff - Email}, MATCH([Manager ID]@row, {Staff - ID}, 0)), "Employee Email Not Found")

What am I missing? Thoughts?

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@Katherine Britt

Your Match function is looking up the text 800014723 and trying to find a match, but in your source data it is stored as a number.

Add the VALUE function to your Manager ID column, and that will convert it to a number.

=VALUE(MID(RIGHT([Manager Name]@row, 11), 2, 9))

All comments

Leibel S

@Katherine Britt

Your Match function is looking up the text 800014723 and trying to find a match, but in your source data it is stored as a number.

Add the VALUE function to your Manager ID column, and that will convert it to a number.

=VALUE(MID(RIGHT([Manager Name]@row, 11), 2, 9))

Katherine Britt

@Leibel S

Thank you thank you thank you!

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.