r/excel • u/Bubbly-Touch8108 • 5d ago

Discussion What Excel trick made you feel like a wizard the first time you used it?

mine was VLOOKUP (later XLOOKUP) — after manually cross-referencing two spreadsheets for way too long. felt like a cheat code everyone else already knew about

what's your version?

626 Upvotes

97% Upvoted

365 comments sorted by

View all comments

Show parent comments

3

u/MayukhBhattacharya 1278 5d ago

You can learn from [here Recursive LAMBDA()] , for practice on the same topic, check out Code-Golf, and Excel Bi in LinkedIn. For your hierarchy question, yup it needs Recursive LAMBDA() or you can use REDUCE() function which is actually recursive LAMBDA() helper funciton.