Forum Discussion

CarlM42's avatar
CarlM42
Copper Contributor
Mar 11, 2025

Multiple lookups from Data base information

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

 

dataItemNamevalues
PL5 Shift3rd
PL4 Ending Partial Pallet / Paleta Parcial Final9
PL4 Starting Partial Pallet / Primera Paleta Parcial 
PL5 Ending Partial Pallet / Paleta Parcial Final0
PL5 Starting Partial Pallet / Primera Paleta Parcial0
PL4 Finished Pallets / Paletas Totales40
PL4 Shift3rd

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.

excel
Formulas and Functions
  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Mar 12, 2025

    How about array formula:

     

    =INDEX(Database[PL5 Starting Partial Pallets], MATCH(1, (Database[Date]=SummaryDate)*(Database[Shift]=SummaryShift)*(Database[Line]=SummaryLine), 0))

     

Resources