How to add another sheet reference into IF formula...

Ulrich Anderhub 1

Hi! I just want to add another sheet reference into the below IF formula... It might need an AND statement, but I could not find a solution for it.

=IF(CONTAINS(Number@row, {Sessions 1 Range 1}), "True", "False")

Any ideas?

Hollie Green

Would need more information about what you are trying to do to know for sure but it sounds like you would need a nested if statement

If(Contains(number@row,{Sessions 1 Range 1}),If(Contains(number@row,{Sessions 2 Range 1},"True","False"))

Ulrich Anderhub 1

Thanks for your feedback! I'll try to use the nested IF statement as you proposed, see here:

=IF(CONTAINS(Number@row, {Sessions 1 Range 1}), IF(CONTAINS(Number@row, {Sessions 2 Range 1}, "True", "False")))

Unfortunately with an Error saying "#INCORRECT ARGUMENT SET".

Basically I want to check if a certain cell in multiple sheets has the same value as in a certain cell (Number column) in the main sheet where the formula is located.

Paul Newcome

Try an IF/OR.

=IF(OR(CONTAINS(sheet1), CONTAINS(sheet2), CONTAINS(sheet3)), "True", "False")

Ulrich Anderhub 1

Ok, this one did not work...

=IF(OR(CONTAINS(Number@row), CONTAINS ({Sessions 1 Range 1}), CONTAINS ({Sessions 2 Range 1})) "True", "False")

Any suggestions?

Paul Newcome

You would use the same CONTAINS syntax you have in your first formula. Just update the range in each for sheet 1, sheet 2, etc..

Ulrich Anderhub 1

I can't make it work... struggle with the syntax. Can you correct this formula accordingly?

=IF(OR(CONTAINS(Number@row), CONTAINS ({Sessions 1 Range 1}), CONTAINS ({Sessions 2 Range 1})) "True", "False")

Thanks for your help! I really appreciate it.

Paul Newcome

You already have the proper syntax for CONTAINS in your original formula:

CONTAINS(Number@row, {Sessions 1 Range 1})

You would use that same syntax but create new cross sheet references in each to point at each of the sheets in question.

Ulrich Anderhub 1

Thanks Paul, it worked now! :-)

Paul Newcome

Happy to help. 👍️