| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not displaying the "#N/A"
Hi everyone, I've a vlookup command that results in a "#N/A" answer on the cell. How can I format the cell so that it won't display the "#N/A"? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517779 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not displaying the "#N/A"
IF(ISNA(VLOOKUP(what,range,col,false)),"",VLOOKUP( what,range,col,false))
HTH -- AP "ledzepe" a écrit dans le message de ... Hi everyone, I've a vlookup command that results in a "#N/A" answer on the cell. How can I format the cell so that it won't display the "#N/A"? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517779 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not displaying the "#N/A"
=IF(ISNA(YourFormula),"",YourFormula)
-- Kind regards, Niek Otten "ledzepe" wrote in message ... Hi everyone, I've a vlookup command that results in a "#N/A" answer on the cell. How can I format the cell so that it won't display the "#N/A"? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517779 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not displaying the "#N/A"
=IF(ISNA(lookup_formula),"",lookup_formula)
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "ledzepe" wrote in message ... Hi everyone, I've a vlookup command that results in a "#N/A" answer on the cell. How can I format the cell so that it won't display the "#N/A"? -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517779 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| functions are not displaying the results | Excel Worksheet Functions | |||
| Fonts not displaying correctly | Excel Discussion (Misc queries) | |||
| Displaying YTD totals as you populate monthly information | Excel Worksheet Functions | |||
| Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Displaying autofilter criteria | Excel Worksheet Functions | |||
Linear Mode
