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.

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.