See your other post.

No need to post more than once.

Biff

"BrettM" wrote in message
...
=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.