Vlookup/networkdays

[grahammal]

=VLOOKUP(F263,'Mobile TRG Rate Card'!$A$2:$G$18,AC263,FALSE)*L263
Is there anyway that a VLOOKUP can be copied into a cell that hasn't got its dependent cells populated yet, so that it dosn't display #N/A.
The above is an example of what I am using.
Also =NETWORKDAYS(H263,I263,T263:AA263) puts a "0" in a cell while waiting for its dependant cells to be populated. I would like the cell to be blank untill it receives its dependant data.
Is any of this possible?

[Niek Otten]

=IF(ISNA(YourFormula),"",YourFormula)
=IF(YourFormula=0,"",YourFormula)

--
Kind regards,

Niek Otten

"grahammal" <[email protected]> wrote in message
news:[email protected]...
>
> =VLOOKUP(F263,'Mobile TRG Rate Card'!$A$2:$G$18,AC263,FALSE)*L263
> Is there anyway that a VLOOKUP can be copied into a cell that hasn't
> got its dependent cells populated yet, so that it dosn't display #N/A.
> The above is an example of what I am using.
> Also =NETWORKDAYS(H263,I263,T263:AA263) puts a "0" in a cell while
> waiting for its dependant cells to be populated. I would like the cell
> to be blank untill it receives its dependant data.
> Is any of this possible?
>
>
> --
> grahammal
> ------------------------------------------------------------------------
> grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
> View this thread: http://www.excelforum.com/showthread...hreadid=521378
>

[grahammal]

Your a diamond, it works perfectly.
Pete