That is an exact match, so if you get 12.5 every time, it either means it
finds it every time, or doesn't, depending upon where the 12.5 is.

It might due to copying and updating the formula, try


=IF(NOT(ISNA(MATCH(A2,$M$1:$M$100,0))),12.5,0)



--

HTH

RP
(remove nothere from the email address if mailing direct)


"PaulOakley" wrote
in message ...

Thanks for your response, the formulae is having problems with the match
type? In the forumale you provided this is the '0' after the lookup
range, do you have any idea what the match type is?

I have tried changing the match type but this makes the result return
12.5 every time.

Thankyou


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile:
http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=386726