E
Eileen
Is there a quick formular that I can change the #n/a (the
result of vlookup) into blank, so I can do the
calculations?
Thanks!
result of vlookup) into blank, so I can do the
calculations?
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BenjieLop
Try this ...
=if(iserror(your_vlookup_formula),"",(your_vlookup_formula))
=if(iserror(your_vlookup_formula),"",(your_vlookup_formula))
A
Andrew
You could use an IF statement combined with ISERROR...
ie. say your formula currently looks like this:
=VLOOKUP(1,A2:C10,2)
Change it to:
=IF(ISERROR(VLOOKUP(1,A2:C10,2)),"",VLOOKUP(1,A2:C10,2))
ie. say your formula currently looks like this:
=VLOOKUP(1,A2:C10,2)
Change it to:
=IF(ISERROR(VLOOKUP(1,A2:C10,2)),"",VLOOKUP(1,A2:C10,2))
B
Biff
An alternative, although error trapping is a good idea:
Leave the #N/A and use an ISNUMBER call in your
calculations:
=SUM(IF(ISNUMBER(A1:A100),A1:A100))
Entered as an array: CTRL,SHIFT,ENTER
Biff
Leave the #N/A and use an ISNUMBER call in your
calculations:
=SUM(IF(ISNUMBER(A1:A100),A1:A100))
Entered as an array: CTRL,SHIFT,ENTER
Biff
A
Aladin Akyurek
If efficiency (speed) is of interest to you, try to use the 2-cell approach:
Y2:
=VLOOKUP(...,0)
X2:
=IF(ISNA(Y2),"",Y2)
Y2:
=VLOOKUP(...,0)
X2:
=IF(ISNA(Y2),"",Y2)