| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get rid of #N/A
when ever we are using some lookup function, in case if there is no
corresponding value, we get #N/A so let me know how to get rid of it |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get rid of #N/A
Maybe:-
=IF(ISNA(VLOOKUP(A1,B1:C3,2,FALSE)),"Not Found",VLOOKUP(A1,B1:C3,2,FALSE)) Mike "Mahesh" wrote: when ever we are using some lookup function, in case if there is no corresponding value, we get #N/A so let me know how to get rid of it |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to get rid of #N/A
Example formula to trap for #N/A
=IF(ISNA(VLOOKUP(G2,$C$1:$F$31,2,FALSE)),"",VLOOKU P(G2,$C$1:$F$31,2,FALSE)) Gord Dibben MS Excel MVP On Wed, 28 Nov 2007 03:00:02 -0800, Mahesh wrote: when ever we are using some lookup function, in case if there is no corresponding value, we get #N/A so let me know how to get rid of it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
