Yes. Do:

=IF(ISERROR(VLOOKUP(A1,RANGE,2,0)=TRUE),0,VLOOKUP( A1,RANGE,2,0))

Where RANGE is of course your vlookup reference point and A1 is cell to
lookup.
Good luck
--
Rob Gaffney


"pawan" wrote:

vlookup funtion is returning me #N/A but can I get this replaced with 0 or
blank