the following formula [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=(INDEX(MATCH(C105,C100:C160,0),MATCH("week 2",C99:AH160,0))) give a #n/a error Should find 146.83 value
This formula [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=INDEX(C100:AH160,6,3) gives the correct answer of 146.83
the week 2 column is from another column and pasted special as values.
What have I done wrong.
Pretty new at this.
John McLean[/FONT][/FONT]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This formula [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=INDEX(C100:AH160,6,3) gives the correct answer of 146.83
the week 2 column is from another column and pasted special as values.
What have I done wrong.
Pretty new at this.
John McLean[/FONT][/FONT]
week 1 | week2 | week 3 | week 4 | week 5 | ||
Betty McLean | 114.83 | |||||
Jim Karasimos | 189 | |||||
Jack StevenHaagen | 115.83 | |||||
John McLean | 180.5 | |||||
0 | 0 | |||||
Verna Mortensen | 146.83 | |||||
Ken Killen | 184.83 | |||||
Joyce Banks-Stevenhaagen | 140.5 | |||||
Alex McKinnon | 96.333 | |||||
0 | 0 | |||||
Linda Carter | 104.22 | |||||
Patricia Renaud | 132.33 | |||||
Dan Murphy | 102.43 | |||||
Evelyn Farrah | 99.889 | |||||
0 | 0 | |||||
Gerry Revelle | 149.33 | |||||
Norman Faulkner | 111 | |||||
Kerry Hietala | 134 | |||||
Don Busch | 83.167 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>