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!