| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with using match and index functions
=IF($B2="","No EIN to Match", INDEX(L2:L34,MATCH($B12,M2:M34,0)))
for a while this worked and then 1 of the rows came up with #NA then more and more of the 20 rows became #NA now all i get is the formulas. my B2 column is imported in general format and i have to change the formats to custom #########. L2:L34 is look for a match in B2 then goes left to M2:M34 to find match to move to A2 please help gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index and Match Functions | Excel Worksheet Functions | |||
| Nesting Index and Match Functions | Excel Worksheet Functions | |||
| Index and match functions help needed. | Excel Worksheet Functions | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
| Index match problems | Excel Worksheet Functions | |||
Linear Mode
