I have a formula that says #incorrect argument set but I can't see where the error is.
Here is the formula in the cell:
=IFERROR(IF([Quorum ID]@row = "", "", VLOOKUP([Quorum ID]@row, {Per Email Report Range 2}, 24, 0)), "TBD")
This forumla should be pulling information from another sheet to fill in 5 columns. I reloaded the data shuttle as well but still keep getting the same error message
Answers
-
Is that error present in any cell being referenced within the formula?
-
No, the error is not in any of the cells that are being referenced.
-
Have you made sure the {Per Email Report Range 2} range is in fact at least 24 columns wide?
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!