| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
| Match Index | Excel Worksheet Functions | |||
| Match or Index Question | Excel Worksheet Functions | |||
| Match & Index | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Hybrid Mode
