What is the Q3 formula then, so I can try that, because as I said, the first
worked for me.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"andyell" wrote in
message ...

Thanks bob, but Q3 is the result of another look up and calculations so
is definitely not text.
and the amended formula did nothing

Thanks anyway

Andy


--
andyell
------------------------------------------------------------------------
andyell's Profile:
http://www.excelforum.com/member.php...o&userid=35272
View this thread: http://www.excelforum.com/showthread...hreadid=560486