Forum

Anthony C
@fowzee
Active Member
Joined: Sep 1, 2019
Topics: 1 / Replies: 2
Reply
RE: Returning first instance of non-zero, non-null item from an Array

The final thing I've tried is this: =INDEX(ColorList, MATCH(TRUE,ISNUMBER(SEARCH(ColorList,$B$2)),0)) This seems to work if I enter it with CTRL...

6 years ago
Reply
RE: Returning first instance of non-zero, non-null item from an Array

I have tried it a slightly different way as well, the final two evaluations come out to this: =INDEX(ColorList,SUMPRODUCT({FALSE;FALSE;TRUE;FALSE;F...

6 years ago