P
pawan
vlookup funtion is returning me #N/A but can I get this replaced with 0 or
blank
blank
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gaffnr
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
=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
J
Jacob Skaria
=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
=IF(ISERROR(VLOOKUP),"",VLOOKUP) will return blank
VLOOKUP(<lookup>,<range>,<column>,FALSE)
If this post helps click Yes
M
Max
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
=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
D
David Biddulph
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))