| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with this Match formula
I wish to lookup a phone number and return the name associated with this
number. Thus I have 2 range names (1) PhoneNumbers, (2) PhoneNames. The number I wish to return the name for is in B5 but it returns a #N/A value and not sure why. See formula I am using below Note both range names are the same length. There are some leading Zero's with the Phone Numbers =IF(B5=0,"",INDEX(PhoneNumbers,MATCH(B5,PhoneNames ,0))) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX and MATCH in one formula... | Excel Worksheet Functions | |||
| Excel Lookup MATCH formula | Excel Discussion (Misc queries) | |||
| Help with formula statament with a MATCH. | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Array formula returning wrong results | Excel Discussion (Misc queries) | |||
Threaded Mode
