Improve cell link formula

While doing the cell link formulas, one of the columns shows data even if the key identifier used is blank (Client ID), would you know why is it happening? but when the client ID column is filled, the column/row were able to update/pull the correct data.

here's the formula I used:

=INDEX({Client View Sales Region}, MATCH([Client ID]@row, {Client View Client ID}, 0))

Find more posts tagged with

Accepted answers

All comments

The sheet the data is being extracted from could have a black Client ID and whatever that row contains is what is being pulled. I would look through the data for any missing Client ID or extra rows.

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.