I have a weekly download of data in Excel. I want to
populate cells based off of search criteria. For
instance: I have a name column, date column and location
column. I want to populate all cells matching:

Name X and Date X by location.

Location 1
data

Location 2
data

Can this be done in Excel within reason?