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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!