Returning a Cell with Matching Data

In a summary collection sheet (Sheet B), I want to capture a certain price in my data collection sheet (Sheet A)

Sheet A has data input:

In sheet B, I want to return the cost only if Material and Part are equal. I was having trouble using the Index(Match) formula and was hoping someone could guide me to the correct formula to use.

If Column A is the same as Column B, return the value of Column C.

Find more posts tagged with

Accepted answers

Melissa Yamada

Hello @Jenn W.

How about adding a helper column (checkbox) that will identify the rows where Material and Part are equal on your sheet A.

Something like:

=IF(Material@row=Part@row,1,0)

Then on your Sheet B, you can add an INDEX/COLLECT formula:

=INDEX(COLLECT({Total Cost},{Helper Column},1),1)

All comments

Melissa Yamada

Hello @Jenn W.

How about adding a helper column (checkbox) that will identify the rows where Material and Part are equal on your sheet A.

Something like:

=IF(Material@row=Part@row,1,0)

Then on your Sheet B, you can add an INDEX/COLLECT formula:

=INDEX(COLLECT({Total Cost},{Helper Column},1),1)

Jenn W.

Yes - that did the trick. Thank you, Melissa!

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.