use IF(ISNA(VLOOKUP(.......)),"0",VLOOKUP(.......))
Ο "kosciosco" έγραψε στο μήνυμα
...
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