View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Belinda7237 Belinda7237 is offline
external usenet poster
 
Posts: 106
Default match formula question with isna


I need to match using two columns - this doesnt see to be working:

=IF(ISNA(MATCH(I11&J11,'Projected MCE Report Northern C'!I:I &'Projected MCE
Report Northern C'!J:J,0)),"",INDEX('Projected MCE Report Northern
C'!U:U,MATCH(I11&J11,'Projected MCE Report Northern C'!I:I &'Projected MCE
Report Northern C'!J:J,0),1,0))

wondering what i have done wrong: If the data in I 11 and J 11 match my
second report column i and J then i want to get the data in colum U.