Formula error message
Options
I have the following formula set up and am getting #Invalid Data Type:
VLOOKUP(EmployeeName@row, {Testing Data Range 1}, {Testing Data Range 2}, false)
I'm trying to search for the string in the EmployeeName column of the current sheet in the current row of the formula in the first column of the other sheet, and return the second column of that sheet to the cell.
All columns are text/number
What am I doing wrong?
Answers

Your VLOOKUP parameters are incorrect. Should be
VLOOKUP(EmployeeName@row, {Testing Data Range}, 2, false)
The {Testing Data Range} should have first column as employee name and you can have any number of columns after that. From that range you are looking for whatever the 2nd column value is.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!