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)))
As a variation, also using FILTER, this makes use of a "helper column" See the attached file
=FILTER($D$2:$D$13,($A$2:$A$13=$G2)*($C$2:$C$13=H$1))
- Thank You both. This is very helpful!
