Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF #REF1 = ERROR then #REFBLANK
=IF(ISERROR(IF(OR($A4=$B$2,$A4<$B$2),'W:\Aurora Daily Production
Report\2005\10_Oct\[2005October01.xls]Daily Report'!$H$49,""))=TRUE,"",IF(OR($A4=$B$2,$A4<$B$2 ),'W:\Aurora Daily Production Report\2005\10_Oct\[2005October01.xls]Daily Report'!$H$49,"")) Ok heres my code. Problem is the *.xls file isn't created yet. Which causes me to press ESC for the referance. Is there a ISERROR or IF statement I could use to have the referance just be blank ( "" ) if the referance doesn't exsist.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|