| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookupand #na
how do avoid displaying #na when vlookup funcion is used and value does not
exist in the 'looked up' table? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookupand #na
=IF(ISNA(YourFormula),"",YourFormula)
-- Kind regards, Niek Otten "monia13" wrote in message ... how do avoid displaying #na when vlookup funcion is used and value does not exist in the 'looked up' table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
