vlookup problem
 

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

vlookup problem
 

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


"puiuluipui" wrote in message
...
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

vlookup problem
 

it was very helpful. thanks.

"Nick Hodge" wrote:

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


"puiuluipui" wrote in message
...
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