When I use a lookup formula in certain circumstance it returns a #N/A.

How can I show this as a zero so that I can sort on this?

Thanks

Simon


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=319640