VLOOKUP Based on Name and Date


I am having some trouble with a query allowing me to look up values based on the name of an individual AND within a certain date range.

The data table is weekly updated with new values, and has multiple fields, including name, date and comments.

I need to pull a comments field, based on name and date.

Thank you in advance!