How to Combine Two VLOOKUP Formulas into 1

Hi,

I have two VLOOKUP formulas that work independently:

=VLOOKUP([Iteration Name]@row, {HH Release Schedule Sprint 1}, 5, false)

=VLOOKUP([Iteration Name]@row, {HH Release Schedule Sprint 2}, 5, false)

How do I combine these with an OR? I want the formula to look in 1 schedule, if it doesn't find a match, look in the other schedule. (the result will always be in one or the other)

I tried some IF(ORs but got tripped up in the logic.

Find more posts tagged with

Accepted answers

Bassam Khalil

Hi @SergeantPup,

In Smartsheet, you can achieve the functionality you're looking for by using the IFERROR function, rather than IF or OR. The IFERROR function allows you to specify a fallback formula if the primary formula results in an error, such as when the VLOOKUP does not find a match in the first dataset. Here's how you can structure this:

=IFERROR(
   VLOOKUP([Iteration Name]@row, {HH Release Schedule Sprint 1}, 5, false),
   VLOOKUP([Iteration Name]@row, {HH Release Schedule Sprint 2}, 5, false)
)

All comments

Bassam Khalil

Hi @SergeantPup,

=IFERROR(
   VLOOKUP([Iteration Name]@row, {HH Release Schedule Sprint 1}, 5, false),
   VLOOKUP([Iteration Name]@row, {HH Release Schedule Sprint 2}, 5, false)
)

SergeantPup

@Bassam Khalil that worked beautifully. Thank you.

Bassam Khalil

@SergeantPup

Happy for you! If you need any more help, please don't hesitate to call.

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.