Try this, F4, copy down & across
=IF(COUNTIF(INDEX($A$5:$C$10,0,MATCH(F$2,$A$3:$C$3,0)),$E4),F$3,"")
Try this, F4, copy down & across
=IF(COUNTIF(INDEX($A$5:$C$10,0,MATCH(F$2,$A$3:$C$3,0)),$E4),F$3,"")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks