ExcelBanter - INDEX then MATCH

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - INDEX then MATCH (https://www.excelbanter.com/excel-worksheet-functions/73164-index-then-match.html)

BrettM

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.

Biff

INDEX then MATCH

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.

All times are GMT +1. The time now is 07:26 PM.