Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Hi everyone,
Once again I need your help, and I thank you in anticipation for your kind help and support. I am using a vlookup formula to get results from sheet 2 to sheet 1. When the result is not available I get #NA by default. My problem is that in this occasion I know that I should not get a result, is there a posibility to eliminate the #NA from the cell, or maybe change it to a 0. I know that I can use conditional formatting and maybe change font to white, but I need to export this sheet into another system and I think it will not be able to recognise the #NA. Thank you Albert |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Use an ISNA error trap, eg:
=IF(ISNA(vlookup(..)),0,vlookup(..)) which returns zero for unmatched cases Adapt the return to suit -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "albertmb" wrote: Hi everyone, Once again I need your help, and I thank you in anticipation for your kind help and support. I am using a vlookup formula to get results from sheet 2 to sheet 1. When the result is not available I get #NA by default. My problem is that in this occasion I know that I should not get a result, is there a posibility to eliminate the #NA from the cell, or maybe change it to a 0. I know that I can use conditional formatting and maybe change font to white, but I need to export this sheet into another system and I think it will not be able to recognise the #NA. Thank you Albert |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Thank you Max, it worked perfectly.
"Max" wrote: Use an ISNA error trap, eg: =IF(ISNA(vlookup(..)),0,vlookup(..)) which returns zero for unmatched cases Adapt the return to suit -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "albertmb" wrote: Hi everyone, Once again I need your help, and I thank you in anticipation for your kind help and support. I am using a vlookup formula to get results from sheet 2 to sheet 1. When the result is not available I get #NA by default. My problem is that in this occasion I know that I should not get a result, is there a posibility to eliminate the #NA from the cell, or maybe change it to a 0. I know that I can use conditional formatting and maybe change font to white, but I need to export this sheet into another system and I think it will not be able to recognise the #NA. Thank you Albert |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Welcome, good to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "albertmb" wrote in message ... Thank you Max, it worked perfectly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |