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