Need Urgent help please...is this even possible

[zubairahmed89]

Hello Gurus
I need your help

I want to know How to link today's date against numerous dates mentioned in single column against the name of a person and completion status of that thing (like: Draft, In progress, Pending etc) I am attaching the excel sheet which i am working on.

In attachment on SHEET 1 Column G is where I want that formula. That formula will compare today's date against target dates, name of a person and Status from Sheet named (INVESTIGATIONS) from columns E and D respectively.



I hope I was able to define the problem well. Can anybody help, is it even possible?

Regards
Zubair