Forum Discussion
Ashnarug
Jan 21, 2025Copper Contributor
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 )
- dougemesBrass Contributor
=FILTER($F$14:$F$60, $B$14:$B$60=$B$8,)
- Vesa RuusunenCopper Contributor
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.