DataTable - Lookup Mode with multiple values

I am attempting to use DataTable to pull compliance information into a sheet.

The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot use 2 identifiers.

Is there a way around this or a way I am not thinking of to match the data? I don't think I can use the Add & Update Mode because I have ~300 Codes and 30 Divisions and the combinations are random.

I have it just using the Lookup Mode now, but the data wont necessarily be correct if I can't filter on 2 criteria.

Target sheet:

DataTable:

Find more posts tagged with

functionality

DataTable

lookup

Accepted answers

Neil Egsgard

@Natalia Kataoka , would either of these options work?

1. Update your DataTable with the a combined indentifier.

2. Pull some of the data into a separate sheet using a separate DataTable Connector and then use a DataMesh to combine the data onto the final sheet.

Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology

All comments

Neil Egsgard

@Natalia Kataoka , would either of these options work?

1. Update your DataTable with the a combined indentifier.

2. Pull some of the data into a separate sheet using a separate DataTable Connector and then use a DataMesh to combine the data onto the final sheet.

Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology

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.