Hi
I have a question I need some help with. I want to create a formula that will check multiple cells against multiple Finish Dates in a spreadsheet. The formula I have to check the first cell is:
=IF(VLOOKUP(I11,A:F,6,FALSE)<TODAY(),"At Risk","On Time")
and this works fine but I would also like to check columns J to Z in the same formula. I am trying to avoid using VBA so that it can be used in the future by users who are not familiar with VBA.
Any help would be appreciated.
OTPM