Utahyankeefan2
New Member
- Joined
- Jan 27, 2019
- Messages
- 3
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[FONT="]([/FONT][FONT="]W9[/FONT]="",[FONT="]X9[/FONT]=""[FONT="])[/FONT]," ",INDEX[FONT="]([/FONT][FONT="]$F$8:$O$17[/FONT], MATCH[FONT="]([/FONT][FONT="]Z9[/FONT],[FONT="]$B$8:$B$17[/FONT],0[FONT="])[/FONT],MATCH[FONT="]([/FONT][FONT="]AA9[/FONT],[FONT="]$F$4:$O$4[/FONT],0[FONT="])[/FONT]))
This populates a winner who has the two matching numbers. What I am trying to do, is from that cell offset 4 additional winners like the box below. When I write the offset and use the cell that the above formula is in, it does not select the winner in the 100 squares. instead it moves up one and over one from the cell that has the formula in it.
[TABLE="width: 174"]
<colgroup><col width="58" span="3" style="width: 58pt;"></colgroup><tbody>[TR]
[TD="class: xl64, width: 58, align: center"] [/TD]
[TD="width: 58"][/TD]
[TD="class: xl64, width: 58, align: center"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63, align: center"]WINNER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"] [/TD]
[TD][/TD]
[TD="class: xl64, align: center"] [/TD]
[/TR]
</tbody>[/TABLE]
I am sure I am not making sense. But any help would be greatly appreciated. Thanks
=IF(OR[FONT="]([/FONT][FONT="]W9[/FONT]="",[FONT="]X9[/FONT]=""[FONT="])[/FONT]," ",INDEX[FONT="]([/FONT][FONT="]$F$8:$O$17[/FONT], MATCH[FONT="]([/FONT][FONT="]Z9[/FONT],[FONT="]$B$8:$B$17[/FONT],0[FONT="])[/FONT],MATCH[FONT="]([/FONT][FONT="]AA9[/FONT],[FONT="]$F$4:$O$4[/FONT],0[FONT="])[/FONT]))
This populates a winner who has the two matching numbers. What I am trying to do, is from that cell offset 4 additional winners like the box below. When I write the offset and use the cell that the above formula is in, it does not select the winner in the 100 squares. instead it moves up one and over one from the cell that has the formula in it.
[TABLE="width: 174"]
<colgroup><col width="58" span="3" style="width: 58pt;"></colgroup><tbody>[TR]
[TD="class: xl64, width: 58, align: center"] [/TD]
[TD="width: 58"][/TD]
[TD="class: xl64, width: 58, align: center"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63, align: center"]WINNER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"] [/TD]
[TD][/TD]
[TD="class: xl64, align: center"] [/TD]
[/TR]
</tbody>[/TABLE]
I am sure I am not making sense. But any help would be greatly appreciated. Thanks