Forum Discussion
Solved
looking for a function
Wondering if possible. search the number values between B14 and B60, if equal to number in cell B8 then give me the number value of the same line in column F14 and F60.
=FILTER($F$14:$F$60, $B$14:$B$60=$B$8,)
As variant
=TOCOL( $F$14:$F$60/($B$14:$B$60=$B$8), 2 )