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'

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

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

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