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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!