Hello, I wanted to ask related to If function's evaluation.
In screenshot 1, for cell A10, I evaluated the formula and though the other sheet - all questions has a range of questions, why does it only pick only one (which is already on A10) value and returns false.
My aim was to understand how A10 is appearing in question explorer.
I have included the file link as well for your reference for sheets - Question Explorer and all_questions. Transport File Link