Formula error message

Sidonia Posteuca

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?

Sameer Karkhanis

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.