Forum Discussion
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
| 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.
3 Replies
Thanks for the suggestion, I have tried that and it still is not working.
How about array formula:
=INDEX(Database[PL5 Starting Partial Pallets], MATCH(1, (Database[Date]=SummaryDate)*(Database[Shift]=SummaryShift)*(Database[Line]=SummaryLine), 0))I discovered the best option was to make a new column that solved for one of the lookup options and then in main column use that result as part of the xlookup function.
