r/learnpython • • Apr 13 '22

What is difficult in excel but easy in Python?

If you were to introduce an established excel user [non VBA] to Python, what would you suggest?

What would amaze them? In as few a lines as possible?

404 Upvotes

241 comments sorted by

View all comments

Show parent comments

3

u/SMAMtastic Apr 13 '22

I’ve been an INDEX(MATCH) stan for a few years now but just recently made the switch to XLOOKUP.

0

u/Eurynom0s Apr 14 '22

INDEX/MATCH is easier to understand than VLOOKUP, but I can never remember which order the lookup and return columns go in. I haven't had a chance to use it yet but XLOOKUP seems like it's basically INDEX/MATCH but it'll actually be clear which column to put in where as you're typing things in.

1

u/flashmedallion Apr 14 '22

but I can never remember which order the lookup and return columns go in

It literally tells you as you type it out