# 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.

• ✭✭✭✭✭✭

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.khalil2009@gmail.com

• ✭✭✭✭✭✭

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.khalil2009@gmail.com

• @Bassam Khalil that worked beautifully. Thank you.

• ✭✭✭✭✭✭

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

bassam.khalil2009@gmail.com