Vlookup

[Ingi K Magnusson]

Hi,

How can I get rid of #N/A appearing in a cell that doesn't
return value from Vlookup function. Can't sum up the cell
when #N/A appears in a cell

Best regards

Ingi

 

[Peo Sjoblom]

Two ways, keep the errors since it is information and use SUMIF

=SUMIF($E$2:$E$200,"<>#N/A")

or wrap the vlookup

=IF(ISNA(MATCH(A1,$B$1:$C$200,0)),0,VLOOKUP(A1,$B$1:$C$200,2,0))

the latter the error message is replaced with a zero, now if I only could
write that in Icelandic <g>

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)