Hello,
I'm trying to create a formula that bounces a cell string ("Lookup") off a list of rows. If all cells within a row of "terms" is found (anywhere in the entire list of terms), then I want to return the value of "TRUE". It would also be awesome if I would be able to return a concatenation of the found row (I'm on 2016, so I have access to the concat and jointext functions).
Example:
<tbody>
</tbody>
<tbody>
</tbody>
Thanks!
I'm trying to create a formula that bounces a cell string ("Lookup") off a list of rows. If all cells within a row of "terms" is found (anywhere in the entire list of terms), then I want to return the value of "TRUE". It would also be awesome if I would be able to return a concatenation of the found row (I'm on 2016, so I have access to the concat and jointext functions).
Example:
Lookup | Found | |
Excel Formulas Can Be Really Easy | True | 1 |
But I Cannot Figure This One Out | False | |
I Would Really Appreciate Any Help | True | 3 |
Thank You For Your Time | False |
<tbody>
</tbody>
row | Term 1 | Term 2 | Term 3 |
1 | Excel | Easy | |
2 | Thank | Time | Apple |
3 | Appreciate | Help | Would |
<tbody>
</tbody>
Thanks!
Last edited: