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

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!