If cell matches cell in another sheet, return value from a column in that other sheet

Im working on a formula that will compare my Client ID column from my current sheet current row, to my Client ID column on my second sheet (called Production Log). When the client ID matches, I want the check date column from my second sheet to be returned.

This is my formula. It is giving me an unparseable error.

=IFERROR(INDEX(COLLECT({Production Log 1st pr date},{Production Log Client ID},HAS(@cell,[Client ID]@row)),1)"no match")

Find more posts tagged with

Formulas

functionality

Accepted answers

Mike TV

@cugbug

You should be able to do this with just a simple INDEX MATCH formula such as:

=IFERROR(INDEX({Production Log 1st pr date}, MATCH([Client ID]@row, {Production Log Client ID}, 0)), "no match")

All comments

Mike TV

@cugbug

You should be able to do this with just a simple INDEX MATCH formula such as:

=IFERROR(INDEX({Production Log 1st pr date}, MATCH([Client ID]@row, {Production Log Client ID}, 0)), "no match")

cugbug

@Mike TV You are simply amazing, thank you!!

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.