Hi OTPM,

Given there are two or more ranges, in which either might have a true/false result, you need to clarify what happens if one is true and the other false. The following approach works if either if true:
=IF(OR(VLOOKUP(I11,A:F,6,FALSE)<TODAY(),VLOOKUP(I1 1,J:O,6,FALSE)<TODAY()),"At Risk","On Time")
To require both to be true, change the OR to AND

Also, I'm not sure how you plan to extend the range all the way to column Z. I've assumed you're using the same offsets from J as for A, but maybe that's not so.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul
Many thanks for the prompt response. However this does not appear to gie me what I need. What I am trying to do is provide an indication as to whether a Task/Milestone is at risk if dependant tasks are running late without having to give management the full project plan.
I attach my sample spreadsheet and in H14 I have put your formula and got the result#N/A.
Basically in any given row I may have dependencies from column I through to Z. I want to check if any of those dependent tasks are running late and therefore makes the Milestone at risk before it actually happens.
Hope this makes it more clear.
any help would be appreciated.
Tony

Attached Files

At Risk Milestone Report.xlsx (12.8 KB, 28 views)