Vlookup Formula help

Pamb10
Pamb10 ✭✭✭
edited 04/29/21 in Formulas and Functions

I always struggle with formulas....this time VLOOKUP. After creating the formula the cell says #UNPARSEABLE. I'm sure it's something simple, but I always fail in troubleshooting formulas.

I am looking up the username in another sheet and retrieving the Created Date data.

Here are my screenshots. Hope you can tell what I am doing as I had to blur out some things.

Lookup sheet

Field selection from cross reference lookup


If I change the first argument in the VLOOKUP to VLOOKUP(Username@row), .... I get the #INCORRECT ARGUMENT error.

Thanks!

Pam

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!