Scenario:
<tbody>
</tbody>
L53:P53
12 14 20 39 40
Why wouldn't this formula give back a "TRUE" value? I did do the Ctrl-Shift-Enter for the formula.
=INDEX(B2:F5,MATCH(B2:B5,L53:P53,0),"TRUE","FALSE")
TIA
B2:B5 39 | 48 | 53 | 67 | 68 |
<tbody>
</tbody>
L53:P53
12 14 20 39 40
Why wouldn't this formula give back a "TRUE" value? I did do the Ctrl-Shift-Enter for the formula.
=INDEX(B2:F5,MATCH(B2:B5,L53:P53,0),"TRUE","FALSE")
TIA