Vlookup

[NCMIKE]

How can I return a value of zero using a VLOOKUP function instead of
#N/A if the formula doesn't find a value?

 

[Leo Heuser]

One way:

=IF(ISNA(VLOOKUP(Cell,Rng,Col,False)),0,VLOOKUP(Cell,Rng,Col,False))

 

[Pete McCosh]

Enclose it in an If.. function to trap the error:

=Vlookup(a1,a310,2,false)

becomes

=if(iserror(Vlookup(a1,a310,2,false)),0,Vlookup
(a1,a310,2,false))

Cheers, Pete