|
Displaying #N/A as a zero
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 |
| All times are GMT +1. The time now is 01:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com