Why am I getting an #Incorrect Argument Set when all I have done is change the Reference table?
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?
Best Answer
-
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.
Answers
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!