Converting a Vlookup to Index/Match within an IF and IFERROR function

I'm currently using this formula

=IFERROR(IF(DSP@row = "", VLOOKUP(Code@row, {ClientNo}, 7, false), VLOOKUP(DSP@row, {ClientNo}, 5, false)), "")

and it works great. However, I need to delete some columns on my reference sheet that are within the vlookup table. I want to convert the above formula to INDEX MATCH so I don't have to worry about this anymore but I'm just get a blank cell as a result. This is what I'm trying:

=IFERROR(IF(DSP@row = "", INDEX({Client#}, MATCH(Code@row, {Code}, 0)), INDEX(MATCH(DSP@row, {DSP}, 0))), "")

What am I missing?

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Jennifer Lenander ,

You're missing the Index range in the 2nd half of your formula.

=IFERROR(IF(DSP@row = "", INDEX({Client#}, MATCH(Code@row, {Code}, 0)), INDEX({MISSING RANGE}, MATCH(DSP@row, {DSP}, 0))), "")

Mark

All comments

Mark Cronk

Hi @Jennifer Lenander ,

You're missing the Index range in the 2nd half of your formula.

=IFERROR(IF(DSP@row = "", INDEX({Client#}, MATCH(Code@row, {Code}, 0)), INDEX({MISSING RANGE}, MATCH(DSP@row, {DSP}, 0))), "")

Mark

Jennifer Lenander

@Mark Cronk - I feel like such an idiot. I worked on this for longer than I would like to admit and stared at it trying to figure out what was wrong.... Thank you for pointing out my error!

Mark Cronk

Happy to help. Thank you for using the Community.

Mark

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.