#incorrect argument set - vlookup
Hi There,
Probably a simple user error here but I can't seem to get this vlookup formula to work in my SmartSheet. I get the "#incorrect argument set" error
Here is the formula and the lookup range
Here is the lookup table. I want to look up the name from the range above and return the value in the "All Leaders" column below (column 3)
I've exported both sheets to excel and created the vlookup formula and it works. What am I doing wrong in SmartSheet. Thank you!
Best Answers
-
Hey Kyle, your first portion of the vlookup should be a single value. [Alliance partner]@row
Not the range [Alliance partner]1:[Alliance partner]22 you have in there now.
Then just copy the formula down or make it a column formula.
Also, if your columns in your second sheet ever move, your vlookup will break. You can use index/match instead
-
Thank you Ryan! That worked. I was used to vlookup working to look up a range in excel. good to know.
Answers
-
Hey Kyle, your first portion of the vlookup should be a single value. [Alliance partner]@row
Not the range [Alliance partner]1:[Alliance partner]22 you have in there now.
Then just copy the formula down or make it a column formula.
Also, if your columns in your second sheet ever move, your vlookup will break. You can use index/match instead
-
Thank you Ryan! That worked. I was used to vlookup working to look up a range in excel. good to know.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!