Formula error message

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?

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.