Index formula with an or statement

aecross

Hi there -

I am hoping to build a formula that indexes 2 separate sheets (Design and Design 2). I unfortunately do not have a way to create a helper column for these 2 sheets, but i'd like to be able to pull in the store ID # based on the store name.

=INDEX({Design Store ID}, MATCH([Store Name]@row, {Design Store Name}, 0) OR(INDEX({Design 2 Store ID}, MATCH([Store Name]@row, {Design 2 Store ID}, 0))

AravindGP

Hi @aecross,

You can use an IFERROR to search Design 2, if the value doesn't appear in Design sheet.

=IFERROR(INDEX({Design Store ID}, MATCH([Store Name]@row, {Design Store Name}, 0)), INDEX({Design 2 Store ID}, MATCH([Store Name]@row, {Design 2 Store ID}, 0)))

AravindGP

Hi @aecross,

You can use an IFERROR to search Design 2, if the value doesn't appear in Design sheet.

=IFERROR(INDEX({Design Store ID}, MATCH([Store Name]@row, {Design Store Name}, 0)), INDEX({Design 2 Store ID}, MATCH([Store Name]@row, {Design 2 Store ID}, 0)))

aecross

Thank you, @AravindGP! That did the trick!