IFERROR Issue with Vlookup

Anthony Sriranpong

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

Paul Newcome

That means there is an issue with the second VLOOKUP. Double check the range you are referencing. Is that error present in any cell (even those in columns 2 - 5)

Anthony Sriranpong

I have checked the second VLOOKUP and checked the range I am referencing and there doesn't seem to be any errors. It is exactly the same as the first VLOOKUP as the second VLOOKUP is just the first one copied. I have also checked columns 2-5 and there doesn't seem to be any issues there either.

Paul Newcome

Exactly how many columns are included in the second cross sheet reference?

Anthony Sriranpong

There are 28 columns in the second cross sheet reference.

Paul Newcome

Did you check all cells in all rows in all 28 columns for that error? What is the purpose for referencing 28 columns if your VLOOKUP is only using 6?

Anthony Sriranpong

There are a total of 28 columns in the second smartsheet that my formula refers to.

However, I am only using the VLOOKUP to look up information in that one column.

The column i am trying to get information off of on the second smartsheet is in column 6.

Paul Newcome

If you are only looking in columns 1 and 6, then you can adjust your range to only cover those columns. You don't necessarily have to cover all 28 in your range. Doing that means that if anything breaks anywhere on the first sheet, your VLOOKUP is going to break.

Another suggestion would be to replace your VLOOKUP with an INDEX/MATCH. It is more robust and much more flexible as well as requiring fewer cells in your cross sheet references since you only need to link to the required columns and can ignore everything in between.

=INDEX({Other sheet column to pull from}, MATCH([Serial Number]@row, {Other sheet serial number column}, 0))

=IFERROR(INDEX({First sheet column to pull from}, MATCH([Serial Number]@row, {First sheet serial number column}, 0)), INDEX({Second sheet column to pull from}, MATCH([Serial Number]@row, {Second sheet serial number column}, 0)))