Returning a Cell with Matching Data

Jenn W.

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.

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)

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!