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

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

Hi
i would make this
IF(ISNA(VLOOKUP(.......)),0,VLOOKUP(.......))

as other wise the zero is stored as 'Text' and not as numeric value


--
Regards
Frank Kabel
Frankfurt, Germany

"Geovas" schrieb im Newsbeitrag
...
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