Procuct Summary

rizmomin,

Detach/open workbook Index Match If - rizmomin - EF741506 - SDG14.xls.

The formula in cell B4, confirmed with CTRL + SHIFT + ENTER :

=IF(ISNA(INDEX(Jul10!$B$1:$B$5000,MATCH(1,IF(Jul10!$D$1:$D$5000=B$3,IF(Jul10!$I$1:$I$5000=$A4,1)),0))),"",INDEX(Jul10!$B$1:$B$5000,MATCH(1,IF(Jul10!$D$1:$D$5000=B$3,IF(Jul10!$I$1:$I$5000=$A4,1)),0)))

Then copied across to cell R4.

Then copy range B4:R4 down.