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.

match formula question with isna
 

Unless you're using Excel 2007 you can't use entire columns as range
references in an array formula. Use a specific range:

=INDEX(G:G,MATCH(A1&B1,D1:D6&E1:E6,0))

--
Biff
Microsoft Excel MVP


"Belinda7237" wrote in message
...

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.