Multiple lookups from Data base information

[Windows Server]

looking for a method to lookup pallets, the data base has information entered by a form that includes shift and machine 

 

dataItemName	values
PL5 Shift	3rd
PL4 Ending Partial Pallet / Paleta Parcial Final	9
PL4 Starting Partial Pallet / Primera Paleta Parcial
PL5 Ending Partial Pallet / Paleta Parcial Final	0
PL5 Starting Partial Pallet / Primera Paleta Parcial	0
PL4 Finished Pallets / Paletas Totales	40
PL4 Shift	3rd

my summary sheet is looking to match the date (easy) but need to include the lookup value of say PL5 shift value of 3rd, and provide the PL5 ending and starting partial pallets in different cells. I have been able to use xlookup to get all the other data needed but not the shift and pallet information.

 

example xlookup(date&shift&line,table[date]&  (this is where I run into an issue) 

 

any assistance is greatly appreciated.

View the full article