isna vlookup

[Tim]

Hi

I'm using this vlookup to get values from a sheet
named "sub": VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE)
and t works. But when "R1" is not in the lookup table
sub!$J$1:$K$18 I get an #N/A as a result and I changed
the vlookup formula to:
=IF(ISNA(VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE),"",VLOOKUP
(R1,sub!$J$1:$K$18,2,FALSE)) to avoid #N/A but now I
receive an error message for the formula.
Is there anybody who knows how to fix this problem?

 

[Aladin Akyurek]

Hi

I'm using this vlookup to get values from a sheet
named "sub": VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE)
and t works. But when "R1" is not in the lookup table
sub!$J$1:$K$18 I get an #N/A as a result and I changed
the vlookup formula to:
=IF(ISNA(VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE),"",VLOOKUP
(R1,sub!$J$1:$K$18,2,FALSE)) to avoid #N/A but now I
receive an error message for the formula.
Is there anybody who knows how to fix this problem?

A paren is missing:

=IF(ISNA(VLOOKUP(R1,sub!$J$1:$K$18,2,FALSE)),"",VLOOKUP
(R1,sub!$J$1:$K$18,2,FALSE))

 

[Tim]

Thank you Aladin.