isna vlookup

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?

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),"",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))

Thank you Aladin.