How to link todays date against numerous dates mentioned in single column

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 onView attachment Copy of Data.xlsx

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

Anyone? please help

Apologies will keep that in mind. Just looking for help with this question

But until you provide the link requested in post #3, you won't get any help.

AliGW said:

But until you provide the link requested in post #3, you won't get any help.

Click to expand...

It's actually been cross-posted on at least two sites...

Links, then ...

Here
1. https://www.mrexcel.com/forum/excel-questions/1055637-lookup-values-todays-date.html
2. http://www.msofficeforums.com/excel/39080-need-urgent-help-please-even-possible.html

Once again, apologies

Zubair