Thanks for the suggestion, still didn't work.. any other ideas?
--
Tekhnikos


"Bernie Deitrick" wrote:

Tekhnikos,

Your values in H11:H50 need to be sorted ascending, or change the 0 in this
part

MATCH(C3,Scoring!H11:H50,0)

to False:

MATCH(C3,Scoring!H11:H50,False)

HTH,
Bernie
MS Excel MVP



"Tekhnikos" wrote in message
...
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