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 / ...
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.