vlookup error

Nicole Shapiro

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

Neil Watson

Hi @Nicole Shapiro

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....

Nicole Shapiro

That was it! Thank you!!