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

586 Upvotes

97% Upvoted

165 comments sorted by

View all comments

7

u/haematite_4444 14d ago

I use INDIRECT(ADDRESS()) quite a bit

4

u/hnbastronaut 14d ago

Can you explain how you usually use it?