Excel - Multiple search criteria - multiple hits - AGGREGATE instead of VLOOKUP
Multiple search criteria and multiple potential matches? No problem for Excel's AGGREGATE function. The VLOOKUP function may only check a column with one search criterion and then only finds the first match. All of these limitations can be overcome with matrix functions. AGGREGATE(15,6,Array,k) no longer requires the classic matrix notation in curly braces.
This is Excel Video #360 from my channel.
File for download and information at http://thehosblog.com: http://thehosblog.com/2013/05/08/exce...
----------------------------------------------------------------------------
Here you'll find longer articles, files for download, my business information, and even more information on how you can support the channel:
Blog - https://thehosblog.com
---------------------------------------------------------------------------
Would you like to network? Feel free to connect with us on the following services:
XING - https://www.xing.com/profile/Andreas_...
LinkedIn - / thehos
----------------------------------------------------------------------------
Further information is also available on the following social media networks:
Instagram - / at_excel
Twitter - / athehos