How to Combine Two VLOOKUP Formulas into 1

SergeantPup

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.

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)
)

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)
)

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.