Xlookup with multiple lookup arrays

New Contributor

I am having issues using Xlookup with multiple lookup arrays. I'm using a single lookup value (A1) with columns C2:C73....across to AB2:AB73 with the return array being B2. The goal is to look up an original sales order (C) using the serial numbers (D-AB) for reference and then return said sales order.




This formula will not return any value outside of the first lookup array, is this a syntax error or do I need to add another formula? Any help would be appreciated!






2 Replies


Hi, you can solve this with MMULT(). A nice trick from @Hans Vogelaar.

Attached is my example document.

@dscheikey thanks for the support, I will give this a try and see how it goes