Hi Experts,
Kindly refer to the queries and photo below:
I wish to generate a "True or False" result (column I). For example, cell H3 has a number 10, and cell H4 has a number 2, i would like to have a formula to generate True of False:
If the number in cell H3 (10) is in column A , then check if the number in cell H4 (4) is in Row 12, if
NO = False, Yes = True
https://ibb.co/4SKpR8t
Kindly refer to the queries and photo below:
I wish to generate a "True or False" result (column I). For example, cell H3 has a number 10, and cell H4 has a number 2, i would like to have a formula to generate True of False:
If the number in cell H3 (10) is in column A , then check if the number in cell H4 (4) is in Row 12, if
NO = False, Yes = True
https://ibb.co/4SKpR8t
Last edited: