Hi. Hopefully some body can assist me with a problem I'm having.

I have a spreadsheet which auto populates from various different sheets within the same work book returningn results as "in date" or "out of date" if conditiones are meet or not, now this works fine when just returning the value if true or if false. My problem is, I am trying to implement when the value is false that a separate formula is run returning a value from one of two other sheets which relates to that particular ID.