Replacing #N/A with a '0' (zero)
Hi all,
I'm using a Vlookup to pull figures over from another sheet. Is there a way that when there isn't any data to pull across, instead of displaying #N/A it could display a zero? Thanks in advance... Neil |
=IF(ISNA(lookup_formula),0,lookup_formula)
-- HTH RP (remove nothere from the email address if mailing direct) "neilcarden" wrote in message ... Hi all, I'm using a Vlookup to pull figures over from another sheet. Is there a way that when there isn't any data to pull across, instead of displaying #N/A it could display a zero? Thanks in advance... Neil -- neilcarden |
=IF(ISNA(YourFormula),0,YourFormula)
-- Kind Regards, Niek Otten Microsoft MVP - Excel "neilcarden" wrote in message ... Hi all, I'm using a Vlookup to pull figures over from another sheet. Is there a way that when there isn't any data to pull across, instead of displaying #N/A it could display a zero? Thanks in advance... Neil -- neilcarden |
IF(ISERROR(VLOOKUP(C1,$A$1:$B$4,2,0)),0,(VLOOKUP(C 1,$A$1:$B$4,2,0))) neilcarden wrote: Hi all, I'm using a Vlookup to pull figures over from another sheet. Is there a way that when there isn't any data to pull across, instead of displaying #N/A it could display a zero? Thanks in advance... Neil |
Thanks again you guys!!! Excellent...
|
=if(isna(cell_ref),0,cell_ref)
Replace cell_ref with the one cell range being referenced http://HelpExcel.com "neilcarden" wrote: Thanks again you guys!!! Excellent... -- neilcarden |
All times are GMT +1. The time now is 07:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com