I am trying to use the INDEX and MATCH functions based on a calculated value.

=INDEX(Scoring!G11:H50,MATCH(C3,Scoring!H11:H50,0) ,1)

Cell C3 is a calculated value:=C2*C6-E6

The result in the cell is #N/A.. is there a way to use a calculated value in
a MATCH function
--
Tekhnikos