match formula question with isna

B

Belinda7237

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.
 
T

T. Valko

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match with isna formula question 2
SUMPRODUCT formula help?? 1
Sumproduct syntax question 6
match error 3
match formula 2
index match and sum 5
Correct #N/A Value 6
Using Match 4

Top