Forum Discussion

Ashnarug's avatar
Ashnarug
Copper Contributor
Jan 21, 2025

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.

  • dougemes's avatar
    dougemes
    Brass Contributor

    =FILTER($F$14:$F$60, $B$14:$B$60=$B$8,)

     

  • Vesa Ruusunen's avatar
    Vesa Ruusunen
    Copper 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. 

     

Resources