VLOOKUP CROSS SHEET REFERENCE

I am using a vlookup/cross sheet reference to populate when specific criteria are met, such as vendor name and contact number.

The pink area works fine, but when i added additional vendors and contract numbers in GREEN, it is not showing up in the targeted sheet

=IFERROR(IFERROR((VLOOKUP(Payee@row + [Agrmt No. 1]@row, {MATCHING ACTIVE CONTRACTS Range 6}, 6, false)), (VLOOKUP(Payee@row + [Agrmt No. 2]@row, {MATCHING ACTIVE CONTRACTS Range 6}, 6, false))), "Not Found")

Pink section works fine

but the GREEN SECTION NOT MATCHING

Find more posts tagged with

Formulas

Accepted answers

All comments

Sameer Karkhanis

Make sure that your {MATCHING ACTIVE CONTRACTS Range 6} includes all the rows needed for lookup. Better option is to define the range to include entire columns, that is, the [Column 1]:[Column 6] instead of [Column 1]1:[Column 6]20

Bobby1

What would this look like in the formula?

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.