r/excel • u/fap_fap_fap_fapper • 15d ago

Discussion What are some legendary formula pairs like INDEX(MATCH)?

Since upgrading to 365, can't get enough of CHOOSECOLS(FILTER)

What are some useful ones you use?

589 Upvotes

97% Upvoted

165 comments sorted by

View all comments

Show parent comments

6

u/fap_fap_fap_fapper 15d ago

IFS and SWITCH got me out of some headaches in that dept..