Why am I getting an #Incorrect Argument Set when all I have done is change the Reference table?

Robert Tebault

I have a sheet that I am using as a master VLOOKUP table. I needed to duplicate the sheet so I can make updates for an upcoming project and not break my ongoing project using the current sheet. I created a copy of the original sheet and changed the name of it so it would not interfere.

On my sheet using the NEW lookup table I changed the formula that I already have to reference the new sheet and I get a #incorrect argument set error.

This formal works fine but references the old sheet:

=IFERROR(VLOOKUP([Part Number]@row, {Duke Master BOM Range 1}, 2, false), "")

This formula errors out but references the new sheet:

=IFERROR(VLOOKUP([Part Number]@row, {UPDATED Duke Energy Master BOM Range 1}, 2, false), "")

Any Idea what would be causing this?

Robert Tebault

Found my error. It was in the reference table range. Was not referencing the entire sheet that makes up the table only individual columns. Corrected the reference and adjusted the column numbers and error went away.

Robert Tebault

Found my error. It was in the reference table range. Was not referencing the entire sheet that makes up the table only individual columns. Corrected the reference and adjusted the column numbers and error went away.