[fred cook]

You should be able to use a nested conditional formula to populate the necessary fields. For example, you can have it first look for the correct date and then go to the data field for info. You can even have the nested formula look thru an entire spreadsheet, find all the matching data and have it summed in the appropriate field.