| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match & Index won't reconise certain numbers
Perhaps try it as either:
=INDEX(Account!$A$1:$B$2035,MATCH($A5&"",Account!$ A$1:$A$2035,0),2) or =INDEX(Account!$A$1:$B$2035,MATCH(TEXT($A5,"000000 00"),Account!$A$1:$A$2035,0),2) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- " wrote: Hi, Can anyone help again. I have set up a spreadsheet with Match and Index to lookup account numbers, some are just normal numbers and other a prefixed with a letter before the. i.e. 10001230 or E10011 match and index doesn't recognise account numbers a that are true numbers, only the one that start with a letter, i have been using the below formula, can anyone help? =INDEX(Account!$A$1:$B$2035,MATCH($A5,Account!$A$1 :$A$2035,0),2) Regards Linexe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Index/Match in VBA | Excel Discussion (Misc queries) | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| to reconise Y or N with a colour ? | New Users to Excel | |||
Threaded Mode
