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,)
3 Replies
As variant
=TOCOL( $F$14:$F$60/($B$14:$B$60=$B$8), 2 )=FILTER($F$14:$F$60, $B$14:$B$60=$B$8,)
vlookup, xlookup, filter.
xlookup is the easiest.
=xlookup(B8,b14:B60,F14:F60,"no corresbonding value found")
This gives the first match. If you need all matches, then Filter function is better.
=textjoin(";",0,filter(F14:F60;b14:B60=B8,"no corresbonding value found")) would return all numbers concataned to one string.
