How to Return Multiple Values in Excel Lookup Function | Get All Matches!

[@abdelazizallam]

thanks rebekah

[@ziggle314]

Very good exposition. The FILTER function (coupled with the CHOOSECOLS, TAKE, DROP) is really powerful. I use Python, R, and Excel in my work. The improvements in Excel (+Power Query, Power Pivot) have made Excel a credible competitor in the corporate workplace. Thanks for all your effort.

[@RebekahOster]

Wow, I totally agree! And Excel is so much more accessible to non-programmers 😁

[@avierez100]

You speak fast, can you slow down? Thanks.

[@RebekahOster]

Thank you for the feedback!