Vlookup
 

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

Vlookup
 

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

Vlookup
 

=IF(ISERROR(VLOOKUP),0,VLOOKUP) will return 0
=IF(ISERROR(VLOOKUP),"",VLOOKUP) will return blank

VLOOKUP(<lookup,<range,<column,FALSE)

If this post helps click Yes
---------------
Jacob Skaria


"pawan" wrote:

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

Vlookup
 

You could use ISNA to trap just #N/A errors, eg:
=IF(ISNA(Vlookup),0,Vlookup)

Above presumes you wish to be kept informed should errors other than #N/A
arise
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"pawan" wrote:
vlookup funtion is returning me #N/A but can I get this replaced with 0 or
blank

Vlookup
 

=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
--
David Biddulph

"pawan" wrote in message
...
vlookup funtion is returning me #N/A but can I get this replaced with 0 or
blank