Show Multiple Index Matches

[jmcconville18]

I am trying to populate a worksheet that takes information from a table on another worksheet. I have to match three columns and show multiple entries for each correct match. Attached is a sample worksheet.
Invoice.xlsx

The information should be on the "Invoice" sheet. The cells in green are what will be given. The cells in yellow are what should be grabbed from table 1 on "June Sands Tracking Sheet"

The delivery date, Customer and truck number are the given fields.

from there I want it to search the table and populate "Truck BOL #","Sand Yard","Time In Staging", "Time Out of Location", and "Sand Type"

I tried this formula in the BOL # column but it wouldn't work
=IF(OR(C10={"",""}),"",IF(COUNTIFS(Table1[Delivery Date],$B$7,Table1[Truck '#],$E$7)=0,"No Entry",IFERROR(INDEX(Table1[BOL'#],SMALL(IF(Table1[Delivery Date]=$B$7,IF(Table1[Truck '#]=$E$7,ROW(Table1[BOL'#])-MIN(ROW(Table1[BOL'#]))+1)),ROWS(C$11:C19))),"")))


any help is greatly appreciated.

Thanks!

[Jacc]

Personally I prefer to do the complicated array formula in a single helper column to get the row number and then use that rownumber in a more simple formula to extract the data. Gives a "cleaner look" if you ask me. Today I went a little more nuts than usual and used the space operator (intersect) and an extra helper column to get a real sleek appearance of the formulas in the form.

[jmcconville18]

this is impressive. Thank you very much!

[Jacc]

''''''''''''''