INDEX then MATCH
=INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11 ) cannot locate "300" or
any other "numbers" I may enter. This works fine if I add a letter (i.e.
"300E") yet help screens show "numbers" should work ok? Can anyone shed any
light here or offer a better formula? Many thanks in advance.
|