Hi I have a formula that works but I'm sure there is an easier way to do it. I need a formula to display a 1 if there is match two columns to multiple columns on a table.

Count Truck Utilization.xlsx

here's the formula
=IF(COUNTIFS(Table1[Actual Date/Time],A7, Table1[Truck '# - Driver 1],B7)+COUNTIFS(Table1[Actual Date/Time],A7, Table1[Truck '# - Driver 2],B7)+COUNTIFS(Table1[Actual Date/Time],A7, Table1[Truck '# - Driver 3],B7)+COUNTIFS(Table1[Actual Date/Time],A7, Table1[Truck '# - Driver 4],B7)+COUNTIFS(Table1[Actual Date/Time],A7, Table1[Truck '# - Driver 2],B7)>=1,1,0)

basically I've used a bunch or countifs to get the information. I know there's an easier way to do this but i can't put my finger on it.

Any help is greatly appreciated