Forum Discussion
Fomula issue
Hi All, Can someone take a look at my formula and help me understand why the cells in column L is not taking the information correctly? Could it be a formatting problem? Thank you in advance. ...
If I follow correctly, I think you can simplify this. That INDEX-MATCH arrangement uses a lot of calculation resources.
Adjust ranges as needed.
Non-dynamic array solution (Ctrl+Shift+Enter):
=VLOOKUP(A6&B6&K6,CHOOSE({1,2},$O$1:$O$10&$N$1:$N$10&$P$1:$P$10,$Q$1:$Q$10),2,0)
365 Solution:
=XLOOKUP(A6&B6&K6,$O$1:$O$10&$N$1:$N$10&$P$1:$P$10,$Q$1:$Q$10)