the following formula =(INDEX(MATCH(C105,C100:C160,0),MATCH("week 2",C99:AH160,0))) give a #n/a error Should find 146.83 value
This formula =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...