I have 100 cells with different names. I have the following formula to tell me who the winner is by the two numbers entered in two cells...
=IF(OR(W9="",X9="")," ",INDEX($F$8:$O$17, MATCH(Z9,$B$8:$B$17,0),MATCH(AA9,$F$4:$O$4,0)))
This populates a winner who has the two matching numbers. What...