Forum Discussion
Formula for returning words that fall under a specific class
Dear,
I am in search of a formula that can help me achieve the following:
I have 2 colums, the first one contains classes, the second one contains items. My goal is to give all the items ...
Hi Andreas,
That could be as array formula (enter it by Ctrl+Shift+Enter)
=IFERROR(INDEX(DATA!$C$6:$C$14, SMALL(IF($B$2=DATA!$B$6:$B$14, ROW(DATA!$C$6:$C$14)-ROW($B$5),""), ROW()-ROW($B$5))),"")
How it works see, for example, https://www.ablebits.com/office-addins-blog/2017/02/22/vlookup-multiple-values-excel/