index match crossheet

Bobby1

i have sheet A that will look at sheets Q1,Q2,Q3,Q4 TO CONFIRM IF THERE IS A MATCH. and if not to return no match

=IFERROR(IFERROR(IFERROR(IFERROR(INDEX({Q1 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q1 INV 2022 Range 1}, 0)), INDEX({Q2 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q2 INV 2022 Range 1}, 0))), INDEX({Q3 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q3 INV 2022 Range 1}, 0))), INDEX({Q4 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q4 INV 2022 Range 1}, 0))))

Paul Newcome

Are you getting an error or an unexpected output?

Bobby1

@Paul Newcome

yes

Paul Newcome

It looks like each INDEX function has the same range as the MATCH function within it?

Bobby1

yes but referenceing different sheets with the ssame naming convention

Paul Newcome

Ah. I see the issue causing the error now. You aren't specifying an output for the final IFERROR.

=IFERROR(IFERROR(IFERROR(IFERROR(INDEX({Q1 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q1 INV 2022 Range 1}, 0)), INDEX({Q2 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q2 INV 2022 Range 1}, 0))), INDEX({Q3 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q3 INV 2022 Range 1}, 0))), INDEX({Q4 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q4 INV 2022 Range 1}, 0))), "No Match")