#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.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!