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

[@JopaExcel]

Of course, we can also use other functions, such as FILTER. =FILTER(D:D, C:C=M3) But, not all versions of Excel have the Filter function, so using the LOOKUPs functions is still a good dynamic solution.

[@alexrosen8762]

Very powerful and useful technique 👌and a good alternative for those who cannot use the filter function

[@JopaExcel]

Absolutely! Not everyone has the most recent versions of Excel, so LOOKUP functions remains an excellent options. 🙏👍

[@BaraniAccAsst]

How to with value of amount