Invalid Data Error

Hello,

I am using vlookup to create a report table that will sum the total qty of an item based on which item is selected in that drop down. Here is my formula: VLOOKUP([Column 4]6, Site1:[Tear Sample Kits Qty]4, [Column 4]7, false)

When used, I get "#invalid data type error"

Table Image

How can I fix this error?

Thanks in advance,

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

Just replace the [Column 4]7 in your formula with 2 so that your formula looks like,

=VLOOKUP([Column 4]6, Site1:[Tear Sample Kits Qty]4, 2, false)

Miranda

Thanks for the feedback, Sameer! Now, the formulas states it is unparseable... Any insight, why?

Paul Newcome

Double check you column names are matching the column names being used in the sheet.

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.