This should be simple but I'm stuck for days and spent 8 hrs on this today alone. Q1 I would like to look up the number of games played on Sheet 2 in column A for the correct first and last name and place it in Sheet 1 column D. I tried =IF($A3=0,"",INDEX('Court 1'!$A$3:$A$100,MATCH($A3&$B3,'Court 1'!$E$3:$E$100&'Court 1'!$F$3:$F$100,0))) but I get a #value error. Q2 I would do this for the average % Sheet 2 in column B to place in Sheet 1 column E for the correct name. This is what I have so far =IF($A3=0,"",INDEX('Court 1'!$B$3:$B$103,MATCH($A3&$B3,'Court 1'!$E$3:$E$103&'Court 1'!$F$3:$F$103,0))) with the same error. Ideally he column is should accommodate 1000 entries and I need to do this for 50 sheets “courts’
Q3 I would like the values of Sheet 1 Column C to show on Sheet 2 Column D for the corresponding names. I will need to do this for Sheets 2 thru 50.
Can I do this with short calculating times say under 5 seconds. This will have to install and run on many different computers. Thank You in advance. Albert
Sheet 1 'Sort Here'
<tbody>
</tbody>
Sheet 2 ‘Court 1’
<tbody>
</tbody>
PS
I did get it working on another workbook with Braces around the whole formula {=IF($A3=0,"",INDEX('Court 1'!$B$3:$B$103,MATCH($A3&$B3,'Court 1'!$E$3:$E$103&'Court 1'!$F$3:$F$103,0)))} but the strange part is if I click on the formula without changing a thing they disappear and it returns the same error and still errors if I put them back in. Also very long save, sort or calculate time, 1min 12 sec to sort 42 entries on sheet 1 and 11 sec on sheet 2
Q3 I would like the values of Sheet 1 Column C to show on Sheet 2 Column D for the corresponding names. I will need to do this for Sheets 2 thru 50.
Can I do this with short calculating times say under 5 seconds. This will have to install and run on many different computers. Thank You in advance. Albert
Sheet 1 'Sort Here'
| A | B | C | D | E | F | G | |
| 1 | Start | #G’s | Court 1 | #G’s | Court 2 | ||
| 2 | First Name | Last Name | Court | Av% | Ave % | ||
| 3 | Bill | H | 3 | ||||
| 4 | Bill | D | 1 | ||||
| 5 | Albert | P | 2 | ||||
| 6 | Jane | E | 10 |
<tbody>
</tbody>
Sheet 2 ‘Court 1’
| A | B | C | D | E | F | |
| 1 | T#G’s | Avg% | Rank | Start | First | Last |
| 2 | Court | Name | Name | |||
| 3 | 25 | 54.34% | 8 | Albert | P | |
| 4 | 75 | 75.23% | 5 | Bill | D | |
| 5 | 8 | Bill | H |
<tbody>
</tbody>
PS
I did get it working on another workbook with Braces around the whole formula {=IF($A3=0,"",INDEX('Court 1'!$B$3:$B$103,MATCH($A3&$B3,'Court 1'!$E$3:$E$103&'Court 1'!$F$3:$F$103,0)))} but the strange part is if I click on the formula without changing a thing they disappear and it returns the same error and still errors if I put them back in. Also very long save, sort or calculate time, 1min 12 sec to sort 42 entries on sheet 1 and 11 sec on sheet 2
Last edited:
