#INCORRECT ARGUMENT SET
Options
Jess A
✭✭
Hello!
I have a cell in one sheet that has 3 if statements. This cell is populating a value with no issues. Then I have a vlook up in a different sheet that is giving me the #incorrect argument set. I know the formula is correct because it is the same as I'm using in another cell with just the column number changed. Anyone know what could be happening?
Edit: I figured it out my reference wasn't encompassing all the columns.
Answers
-
hi @Jess A ,
so it's not issue anymore?
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!