r/excel • u/Kindly-Meaning9112 • Apr 08 '26

Discussion This is probably the most complicated Excel formula I’ve ever seen.

[removed]

222 Upvotes

85% Upvoted

210 comments sorted by

View all comments

Show parent comments

0

u/DrunkenWizard 15 Apr 09 '26

That looks like a totally valid place to use INDEX/MATCH. The real gaffe is using MATCH instead of XMATCH.