Remember Me?

#1
April 19th 05, 11:33 AM
 Junior Member First recorded activity by ExcelBanter: Apr 2005 Posts: 26
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?

Neil

#2
April 19th 05, 01:45 PM
 Bob Phillips Posts: n/a

=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?

Neil

--
neilcarden

#3
April 19th 05, 01:46 PM
 Niek Otten Posts: n/a

=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?

Neil

--
neilcarden

#4
April 19th 05, 01:53 PM
 Vinaya Posts: n/a

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?

Neil

#5
April 20th 05, 10:19 AM
 Junior Member First recorded activity by ExcelBanter: Apr 2005 Posts: 26

Thanks again you guys!!! Excellent...

#6
April 20th 05, 02:49 PM
 galimi Posts: n/a

=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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mark Excel Discussion (Misc queries) 3 April 7th 05 10:02 PM OhhAhh Excel Worksheet Functions 10 March 4th 05 12:28 AM Tammy Excel Discussion (Misc queries) 4 March 3rd 05 07:33 PM Desperate Don Excel Discussion (Misc queries) 0 March 1st 05 04:23 PM vic Excel Worksheet Functions 1 January 27th 05 09:53 PM

All times are GMT +1. The time now is 11:19 AM.