vlookup problem

[Guest]

I have one problem...I use this vlookup formula in B cells
=IF(A2<>"",VLOOKUP($A2,$J$1:K51,2,FALSE),"") to extract some prices...

A B
1 01254 #N/A
2 total i.s. 12 3.65
3 total i.s. 15 2.86
4 02458 #N/A

I don't want to see #N/A ....I don't want anything to apear in B1, B4....
How can i do this??

Thanks! My best regards,
puiuluipui

 

[Nick Hodge]

Use the error functions (ISERROR, ISERR and ISNA) ISNA in this example

=IF(A2<>"",IF(ISNA(VLOOKUP($A2,$J$1:K51,2,FALSE)),"",VLOOKUP($A2,$J$1:K51,2,FALSE)),"")

ISNA checks for #N/A errors, ISERR check for all errors except #N/A and
ISERROR checks for any error

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk

 

[Guest]

it was very helpful. thanks.

Use the error functions (ISERROR, ISERR and ISNA) ISNA in this example

=IF(A2<>"",IF(ISNA(VLOOKUP($A2,$J$1:K51,2,FALSE)),"",VLOOKUP($A2,$J$1:K51,2,FALSE)),"")

ISNA checks for #N/A errors, ISERR check for all errors except #N/A and
ISERROR checks for any error

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk