Vlookup/networkdays
 

=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

Vlookup/networkdays
 

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

--
Kind regards,

Niek Otten

"grahammal" wrote in message
...

=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

Vlookup/networkdays
 

Your a diamond, it works perfectly.
Pete


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=521378