Help with formula for "If column matches another sheet, check the box"?

ElizabethOwen

Hello there,

I am trying to get this result:

If Branch # on this sheet matches {Branch Number} on reference sheet AND the {Month Name} on the reference sheet is "January", check the box.

Thank you!

Leibel S

@ElizabethOwen

Try this:

=IF(INDEX({Month Name},MATCH([Branch #]@row,{Branch Number},0))="January",1,0)

ElizabethOwen

Thanks @Leibel S

I got this error:

Leibel S

Add an if error:

=IFERROR(IF(INDEX({Month Name},MATCH([Branch #]@row,{Branch Number},0))="January",1,0),0)

ElizabethOwen

Thanks @Leibel S

If {Month Name} has a formula in it, will it cause this to not work? Wondering if my problem is circular.

Leibel S

Are there errors in that column?

What makes you think it is not working?

Is it possible the branch number in 1 place is stored as a text (not a number)?

ElizabethOwen

Thank you! Your questions actually got me thinking about how to fix it and I figured it out. Thank you so much for the formula.