i have following in range c1:d6 -
1 2 b 3 c 6 f 7 g 8 h the formula =match(6,c1:d6,0) returns #n/a. i've searched , other forums without success. appreciated.
it not possible search in multi-dimensional range found workaround in question:
Comments
Post a Comment