This may just be a simple answer that I'm looking too much into.

On my first sheet I have 5 columns of data from where I want to pull information.

[A1]"Pickup Date" [B1]"Truck #" [C1] "Trailer #" [D1] "Customer Name"

On the second sheet I have three of the same columns

[A1] "Pickup Date" [B1]"Truck Number" [C1]"Customer Name"

I'm Wondering if I have supplied the "Pickup Date" and "Truck Number" on the second sheet if I can grab the corresponding "Customer Name" from sheet 1 and paste it into C2 on sheet 2.

Here's the formula I have tried in C2 under customer name. I know it's not in correct format but I need both the Pickup Date and Truck Number to match and paste the

customer name=INDEX(Table1,( MATCH(A1,Table1[Pick Up Date],0)&MATCH(B2,Table1[Truck #],0)),4)
Thanks For your help