vlookup error
I am trying to write my first vlookup formula in Smartsheet and running into an error I can't resolve.
This is the sheet that I am writing the formula in:
This is the formula I've written:
And this is the lookup_table am referencing:
The Detail Status that is my search_value is in the first column of my lookup_table.
My goal is to look up what is entered into the Detail Status column and return column 2 of the lookup_table. I also want an exact match.
The error I am getting is #INCORRECT ARGUMENT SET. Looking at the Formula Error Messages, I can't figure out what argument needs to be removed or what needs to be added.
I appreciate any suggestions!
Nicole
Answers
-
The ",2,false" must be on the right and outside of the parenthesis.
=VLOOKUP([Detail Status]@row, {Project Statuses1},2,false) is my best guess....
-
That was it! Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!