Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - reporting #N/A
Hi, I have a set of master data as a named table, for this purpose "MASTER"
I have numerous sub-sets of data, which I want to reference to MASTER for a certain value. If the key figure is not part of MASTER, the lookup returns #N/A - I was wondering if there was a way of navigating round this, replacing with a zero or something? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - reporting #N/A
Use ISNA() to handle this
=IF(ISNA(vlookupformula),"",vlookupformula) OR =IF(ISNA(vlookupformula),0,vlookupformula) If this post helps click Yes --------------- Jacob Skaria "GD" wrote: Hi, I have a set of master data as a named table, for this purpose "MASTER" I have numerous sub-sets of data, which I want to reference to MASTER for a certain value. If the key figure is not part of MASTER, the lookup returns #N/A - I was wondering if there was a way of navigating round this, replacing with a zero or something? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP - reporting #N/A
Hi
try using ISNA for error handling, eg =IF(ISNA(your formula),"",your formula) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "GD" wrote: Hi, I have a set of master data as a named table, for this purpose "MASTER" I have numerous sub-sets of data, which I want to reference to MASTER for a certain value. If the key figure is not part of MASTER, the lookup returns #N/A - I was wondering if there was a way of navigating round this, replacing with a zero or something? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts used for Reporting ! | Charts and Charting in Excel | |||
Bug reporting | Excel Discussion (Misc queries) | |||
Need help with reporting | Excel Worksheet Functions | |||
Automated Reporting | Excel Worksheet Functions | |||
Vlookup reporting #N/A's | Excel Worksheet Functions |