Formula works in one sheet but not others (cross-refs are updated)

Hi there,

I have a formula in one sheet, which looks at the task and calculates the dates for each task, excluding holidays and weekends.

=IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupDerek}, 2, false), {TechTarget Holidays Range 2}), "")

I then use this same formula in a different sheet, adjusting the reference to the same lookup columns with a different name:

=IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupJared}, 2, false), {TechTarget Holidays Range 2}), "")

Both references point to this:

The formula works as expected in the first sheet (Derek) but does not work at all on the second sheet (Jared). I can't figure out why. I tested both on the same list of tasks.

Derek's sheet has 2,103 rows and Jared's has 536. Any ideas?

Thanks!

Find more posts tagged with

Sheets

Formulas

References

Accepted answers

jmhoward

And I figured it out — I neglected to define the second reference (holidays). D'oh!

All comments

jmhoward

And I figured it out — I neglected to define the second reference (holidays). D'oh!

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.