trying to use cells which have been copied and pasted values only.

[jkmclean]

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]

		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>

 

[arthurbr]

=INDEX(MATCH(C105,C100:C160,0),MATCH("week 2",C99:AH160,0))) misses the range in which you want to look for (normally =INDEX(C1000:AH160,MATCH...,MATCH...)), and in this formula there is a space between "week" and "2". There seems to be no space in the column header in your sample table

 

[jkmclean]

HI there,
I think I have got it.
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=INDEX(C100:AH160,MATCH(C100,C100:C160,0),MATCH(E99,C99:AH99,0))
NOw another question.
When I have entered the data for week3 is there a way to copy the column from d13:d57 to f100:f141 automatically?
Again thanks for the help
John[/FONT][FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]_{^{<strike>
</strike>}}[/FONT]