D
DM
In my worksheet I have a functions that bring me back data based on an
entry...example:
=IF(ISERROR(VLOOKUP(H251,Tivoli,2,FALSE)),"",VLOOKUP(H251,Tivoli,2,FALSE))
=IF(H251="","",VLOOKUP(MONTH(A251),LookUp!$A$13:$B$24,2,FALSE))
=IF(H251="","",VLOOKUP(WEEKDAY(A251),LookUp!$A$3:$B$9,2,FALSE))
Now when I enter an incident number, excel will give me date, month, etc etc
absed on that incident....I also have a column that says if certain fields
associated with taht number are blank, then tell me this was an incident but
has been changed...what i need to do is say if that is the case then also
leave columns A-G blank.....
Thanx
DM
entry...example:
=IF(ISERROR(VLOOKUP(H251,Tivoli,2,FALSE)),"",VLOOKUP(H251,Tivoli,2,FALSE))
=IF(H251="","",VLOOKUP(MONTH(A251),LookUp!$A$13:$B$24,2,FALSE))
=IF(H251="","",VLOOKUP(WEEKDAY(A251),LookUp!$A$3:$B$9,2,FALSE))
Now when I enter an incident number, excel will give me date, month, etc etc
absed on that incident....I also have a column that says if certain fields
associated with taht number are blank, then tell me this was an incident but
has been changed...what i need to do is say if that is the case then also
leave columns A-G blank.....
Thanx
DM