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),"",VLO OKUP
(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?

Tim wrote:
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),"",VLO OKUP
(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)),"",VL OOKUP
(R1,sub!$J$1:$K$18,2,FALSE))

Thank you Aladin.