0 value in null value cell

's Computer Specifications

How do I stop a 0 from showing up in a cell running a lookup function when
there is a null value?

Thanks,
Todd

's Computer Specifications

Hi,
you can use and If statement so can eliminate the 0 or null
Try and let me know

=IF(LOOKUP(C3,F3:I4)=0," ",LOOKUP(C3,F3:I4))

--
Sigmund

"FP Novice" wrote:

> How do I stop a 0 from showing up in a cell running a lookup function when
> there is a null value?
>
> Thanks,
> Todd

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cell value based on null/not null in another cell	=?Utf-8?B?c3BlbmNl?=	Microsoft Excel Worksheet Functions	1	18th Feb 2006 11:49 PM
cell shows 0 when referenced cell is null	=?Utf-8?B?ZGVl?=	Microsoft Excel Worksheet Functions	8	6th Oct 2005 01:39 PM
if cell has null value, move data from one cell to another	looped	Microsoft Excel Programming	1	17th May 2005 12:48 AM
If a cell is not null, insert a formula into another cell	Michelle Hillard	Microsoft Excel Worksheet Functions	3	24th Dec 2003 10:53 PM
Re: Changing a cell to 0 if another cell is null	Matthew Connor	Microsoft Excel Worksheet Functions	0	11th Jul 2003 01:58 AM