The result of =C2*C6-E6 is a number

The values in column H are numbers
--
Tekhnikos


"T. Valko" wrote:

What is the result of =C2*C6-E6 ?

And what kind of values are in H11:H50 ?

What your formula is telling you is that the result of =C2*C6-E6 does not
match any number in H11:H50.

It could be that =C2*C6-E6 returns a decimal value that does not *exactly*
match a number in H11:H50.


--
Biff
Microsoft 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