Issue referencing VLOOKUP data in another formula

Hi,

I have a VLOOKUP pulling in data from another sheet that will be updated on an ongoing basis. The data pulling in is the number of manufacturing days to complete an operation. The VLOOKUP function is working fine.

This is the VLOOKUP formula: =VLOOKUP([Model Series]@row, {Mfg Hours by Model Range 1}, 7, false)

Within the main sheet, I have a second formula (in a different cell) that is looking to the manufacturing start date and then adding the working days necessary to manufacture (looking to the cell with the VLOOKUP data) to then produce the completion data.

This is the formula: =WORKDAY([Mfg Start Date]@row, [Mfg Days Lookup]@row)

The problem is that the WORDAY formula is kicking out this error: #INVALID DATA TYPE

All columns have the same data type in column properties. If I add an IFERROR function before the WORKDAY formula, it kicks out the IFERROR result every time.

Is the issue linking to VLOOKUP data? Is there a better way to do this?

Thanks!

Find more posts tagged with

Formulas

Accepted answers

All comments

Megan Ryzenga

Hello Madeline!

The syntax for WORKDAY is the following: =WORKDAY(date, num_days, [holidays]).

date = date column-type reference

num_days = text/number column-type reference

The column that has the VLOOKUP formula should be a text/number column-type, and the column that has the WORKDAY function should be a date column-type. You mentioned that all columns used with your formulas are date column-types--can you see if updating the column with your VLOOKUP formula to a text/number column-type solves this issue?

Madeline Weitz

@Megan Ryzenga Updated as you suggested, but, unfortunately, I am still getting the same error.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.