Forum Discussion
Xlookup with multiple lookup arrays
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 ...
Hi, you can solve this with MMULT(). A nice trick from HansVogelaar.
Attached is my example document.
