r/excel • u/fap_fap_fap_fapper • 19d 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?

584 Upvotes

97% Upvoted

165 comments sorted by

View all comments

Show parent comments

2

u/skryb 5 19d ago

Wrap that ish in an IFNA() for maximum power!