IFERROR Issue with Vlookup

Options

I am currently trying to make my IFERROR to input data for one of my Smartsheets.

Currently, when the data for the first Vlookup does not have an error there are no issues and the data shows up correctly.

However, if the first Vlookup comes out as an error the cell will not show Incorrect Argument Set.

The formula that I am having issues is with is:

=IFERROR(VLOOKUP([Serial Number]125, {BKK Product Data Range 1}, 6, 0), VLOOKUP([Serial Number]125, {BKK Product Data - old orders Range 1}, 6, 0))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!