Forum Discussion
Solved
How to use Xlookup with spilled range as lookup value? I want the range to spill horizontally.
I'm attaching the sample file. In "Cal" sheet, I want a single cell formula in A2, to lookup values in subsequent columns For some reason Xlookup is spilling lookup vertically in rows. Is ther...
Thank you sirSergeiBaklan
I need to know why we used Xmatch over match, I've gotten the same results with Match.
Also to make the columns dynamic, I've used this.
Is there a better solution?
=INDEX(Enrolment,MATCH(A2#,Enrolment[Name]),SEQUENCE(1,COLUMNS(Enrolment)-2,2)
What is better depends on with which you are more familiar.
MATCH() by default performs approximate search which is not reliable, that's the main difference. XMATCH() has more options. In your case not a big difference.
SEQUENCE/COLUMNS - good enough.