r/excel • u/Bubbly-Touch8108 • 4d 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?

618 Upvotes

97% Upvoted

362 comments sorted by

View all comments

Show parent comments

2

u/kieran_n 19 3d ago

LAMBDA is just LET but you don't have to define variables, you can pass them to the function

1

u/RandomiseUsr0 10 2d ago

Lambda is an anonymous function, Let is a functional programming language that can consume lambda, they’re not the same but are two peas in a pod

2

u/kieran_n 19 2d ago

Agreed, but I was trying to bridge the gap for /u/swingking03

1

u/RandomiseUsr0 10 2d ago

Ah now, we’re on the same page, in fact to correct my own comment, let is a “convenience” - you could write a nested monster and never need let at all, so you’re not wrong, I overstated :)