View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
garyr garyr is offline
external usenet poster
 
Posts: 1
Default 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