I moved a Reference sheet...Formula

Hello, I moved a reference sheet. I updated the new reference sheet in my formula but it doesn't update.

I updated the "reference sheet" then since it wasn't updating I rewrote the formula. Still the same: I get the message: #incorrect Argument.

Below is the formula:

=VLOOKUP([Last Name]@row, {Employee Database Range 4}, 5, false)

Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!