Example: Two columns, A and B
<tbody>
</tbody>
In the above example some values in A are missing in B.
What I would like to do:
Using a formula in one cell only, look at all values in Column A to verify if they appear at least once in column B, so the answer from the formula only needs to be TRUE or FALSE.
A bean carrot pea bean bean apple tomato mango apple beetroot | B pea carrot bean beetroot |
<tbody>
</tbody>
In the above example some values in A are missing in B.
What I would like to do:
Using a formula in one cell only, look at all values in Column A to verify if they appear at least once in column B, so the answer from the formula only needs to be TRUE or FALSE.
Last edited: