Forum Discussion
Solved
Help with formula (Index/lookup)
Hello all I imagine this should be a fairly simple one for some of the geniuses here. In the attachment I have a data array and need a formula which can convert it into a smaller table. Pleas...
=FILTER($C$2:$C$13,($A$2:$A$13=$F2)*ISNUMBER(SEARCH(G$1,$B$2:$B$13)))
=FILTER($C$2:$C$13,($A$2:$A$13=$F2)*ISNUMBER(SEARCH(G$1,$B$2:$B$13)))