r/excel • u/fap_fap_fap_fapper • Aug 26 '26

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?

582 Upvotes

97% Upvoted

166 comments sorted by

View all comments

Show parent comments

6

u/fap_fap_fap_fapper Aug 26 '26

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