If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#N/A = FALSE
I am trying to get rid of #n/a. Using ISNA OR ISERROR, I
Get "FALSE" not the value. The formula I am using is; IF(ISNA(VLOOKUP($A13&C$11,'PC INPUT'!$A:$G,7,FALSE)),"") Any ideas as to what I am doing worng? Thanks for any help |
#2
|
|||
|
|||
#N/A = FALSE
You need to repeat the VLOOKUP part if you are using it in an IF statement
in this way. For example; =IF(ISNA(formula),"",(formula) for yours (untested); =IF(ISNA(VLOOKUP($A13&C$11,'PC INPUT'!$A:$G,7,FALSE)),"",VLOOKUP($A13&C$11,'PC INPUT'!$A:$G,7,FALSE)) "Jon M" wrote in message ... I am trying to get rid of #n/a. Using ISNA OR ISERROR, I Get "FALSE" not the value. The formula I am using is; IF(ISNA(VLOOKUP($A13&C$11,'PC INPUT'!$A:$G,7,FALSE)),"") Any ideas as to what I am doing worng? Thanks for any help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Ugly Macro - Duplicates/Non Numbers/Fill Down | foolio | General Discussion | 12 | August 25th, 2004 10:46 PM |
excel 2003 error>> compile error in hidden module: ThisWorkbook | clayton | General Discussion | 4 | June 22nd, 2004 02:02 AM |
Hide Specific rows. | Steve | Worksheet Functions | 7 | June 9th, 2004 09:27 PM |
ODMA Doc ID Field | Julie | Mailmerge | 3 | May 4th, 2004 07:28 PM |
how to run recorded macros withour showing processing excel sheets | christine | Worksheet Functions | 10 | January 5th, 2004 11:13 PM |