PDA

View Full Version : [SOLVED] Date Lookup Problem



Sully1440
07-25-2018, 10:12 AM
Hi All,
I need your help with a formula to check dates and input a status in a cell. I want the formula to do the following:
1.) If there is a checkmark in the range D4:I4, AND
2.) If the corresponding date in range D2:I2, is greater than today's date, THEN
3.) Cell J4 = "Behind Schedule"

I'd like this formula in each cell for column J compared to the date range in D2:I2. I attached the sample spreadsheet.

I'm thinking this is an if statement with an Index and Match formula, .....or a sumproduct formula but I'm stuck.

Any help would be appreciated.
Thanks,
Jim

Sully1440
07-25-2018, 11:57 AM
I figured it out :thumb :banghead:

=IF((INDEX(DueDate,MATCH("ü",D4:I4,0)))< NOW(), "Behind Schedule", "On Track")