Re: replacing #N/A values with zero values
- From: "Pete_UK" <pashurst@xxxxxxxxxxx>
- Date: 16 Feb 2006 14:02:02 -0800
Remove the quotes from around the TRUE in the middle of the formula. In
fact you don't need that little part, so your formula can become:
=IF(ISERROR(HLOOKUP($A6,'Calgen NC'!$D$5:$T$10,
MATCH('Plant Financing'!E$4,'Calgen NC'!$D$5:$D$10,0),FALSE)),0,
(HLOOKUP($A6,'Calgen NC'!$D$5:$T$10,
MATCH('Plant Financing'!E$4,'Calgen NC'!$D$5:$D$10,0),FALSE)))
Hope this helps.
Pete
.
- Prev by Date: Re: Comparing columns in 2 different worksheets, IF Function
- Next by Date: Re: Function/ formula to output a cell reference
- Previous by thread: Re: replacing #N/A values with zero values
- Next by thread: Re: replacing #N/A values with zero values
- Index(es):
