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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!