Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF isna to avoid #N/A
I've been looking for this answer on previous posts but none found for my
formula : =vlookup($c$3,sheet2!$a$300:$d$400,columns($b:$e), 0) Where do I add the IF ISNA in this Vlookup formula, I tried in different places and "I missed a parentesis", or" too many arguments" or" else". -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF isna to avoid #N/A
=IF(ISNA(VLOOKUP($C$3,Sheet2!$A$300:$D$400,COLUMNS ($B:$E),0)),"",VLOOKUP($C$3,Sheet2!$A$300:$D$400,C OLUMNS($B:$E),0))
In general: =IF(ISNA(YourFormula),"",YourFormula) -- Kind regards, Niek Otten Microsoft MVP - Excel "Learning Excel" wrote in message ... | I've been looking for this answer on previous posts but none found for my | formula : =vlookup($c$3,sheet2!$a$300:$d$400,columns($b:$e), 0) | Where do I add the IF ISNA in this Vlookup formula, I tried in different | places | and "I missed a parentesis", or" too many arguments" or" else". | | -- | Socrates said: I only know, I don''''''''t know nothing. | I say : I don''''''''t even know, I don''''''''t | know nothing. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF isna to avoid #N/A
Forgot 2 things
1- To return the cell empty ( no zeros) 2- Thanks in advance. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Learning Excel" wrote: I've been looking for this answer on previous posts but none found for my formula : =vlookup($c$3,sheet2!$a$300:$d$400,columns($b:$e), 0) Where do I add the IF ISNA in this Vlookup formula, I tried in different places and "I missed a parentesis", or" too many arguments" or" else". -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF isna to avoid #N/A
Try one of these:
There's no need to use columns($b:$e) as your column_index argument. =IF(ISNA(MATCH($C$3,Sheet2!$A$300:$A$400,0)),"",VL OOKUP($C$3,Sheet2!$A$300:$D$400,4,0)) =IF(ISNA(VLOOKUP($C$3,Sheet2!$A$300:$D$400,4,0))," ",VLOOKUP($C$3,Sheet2!$A$300:$D$400,4,0)) =IF(COUNTIF(Sheet2!$A$300:$A$400,$C$3),VLOOKUP($C$ 3,Sheet2!$A$300:$D$400,4,0),"") -- Biff Microsoft Excel MVP "Learning Excel" wrote in message ... I've been looking for this answer on previous posts but none found for my formula : =vlookup($c$3,sheet2!$a$300:$d$400,columns($b:$e), 0) Where do I add the IF ISNA in this Vlookup formula, I tried in different places and "I missed a parentesis", or" too many arguments" or" else". -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF isna to avoid #N/A
Not just missing the If isna in my formula but the "" and the repetition of
the whole formula, no wonder I could not get it. Thanks a lot Niek Otten. As for you T. Valko : Wonderformulas! Thanks guys. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "T. Valko" wrote: Try one of these: There's no need to use columns($b:$e) as your column_index argument. =IF(ISNA(MATCH($C$3,Sheet2!$A$300:$A$400,0)),"",VL OOKUP($C$3,Sheet2!$A$300:$D$400,4,0)) =IF(ISNA(VLOOKUP($C$3,Sheet2!$A$300:$D$400,4,0))," ",VLOOKUP($C$3,Sheet2!$A$300:$D$400,4,0)) =IF(COUNTIF(Sheet2!$A$300:$A$400,$C$3),VLOOKUP($C$ 3,Sheet2!$A$300:$D$400,4,0),"") -- Biff Microsoft Excel MVP "Learning Excel" wrote in message ... I've been looking for this answer on previous posts but none found for my formula : =vlookup($c$3,sheet2!$a$300:$d$400,columns($b:$e), 0) Where do I add the IF ISNA in this Vlookup formula, I tried in different places and "I missed a parentesis", or" too many arguments" or" else". -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF isna to avoid #N/A
You're welcome!
-- Biff Microsoft Excel MVP "Learning Excel" wrote in message ... Not just missing the If isna in my formula but the "" and the repetition of the whole formula, no wonder I could not get it. Thanks a lot Niek Otten. As for you T. Valko : Wonderformulas! Thanks guys. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "T. Valko" wrote: Try one of these: There's no need to use columns($b:$e) as your column_index argument. =IF(ISNA(MATCH($C$3,Sheet2!$A$300:$A$400,0)),"",VL OOKUP($C$3,Sheet2!$A$300:$D$400,4,0)) =IF(ISNA(VLOOKUP($C$3,Sheet2!$A$300:$D$400,4,0))," ",VLOOKUP($C$3,Sheet2!$A$300:$D$400,4,0)) =IF(COUNTIF(Sheet2!$A$300:$A$400,$C$3),VLOOKUP($C$ 3,Sheet2!$A$300:$D$400,4,0),"") -- Biff Microsoft Excel MVP "Learning Excel" wrote in message ... I've been looking for this answer on previous posts but none found for my formula : =vlookup($c$3,sheet2!$a$300:$d$400,columns($b:$e), 0) Where do I add the IF ISNA in this Vlookup formula, I tried in different places and "I missed a parentesis", or" too many arguments" or" else". -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF(ISNA.... | Excel Discussion (Misc queries) | |||
IF ISNA Help | Excel Discussion (Misc queries) | |||
ISNA Help | Excel Worksheet Functions | |||
ISNA help | Excel Worksheet Functions | |||
Using ISNA with OR | Excel Worksheet Functions |