I have a tab in my Google Sheet for my raw data. I have another tab which has the report form which includes the criteria fields which I want to be able use to pull the appropriate data from the raw data tab. I am using "INDEX" and "MATCH" along with my two criteria fields to extract the records in my report. Everything appears to work on the first criteria field by fails on the second criteria field in that it pulls all future dates greater then the date set in the criteria field. My formula is {=ArrayFormula(INDEX('Traffic Discrepancy Log'!$A1:$I,MATCH(1,('Traffic Discrepancy Log'!B:B=C$2) * ('Traffic Discrepancy Log'!D:D=C$1),0),0))}
2021-06-01_11-05-23.png2021-06-01_11-05-55.png
Bookmarks