Forum Discussion

pycharge's avatar
pycharge
Copper Contributor
Apr 29, 2024

Excel: Lookup '1' and return multiple values

This seems rather simple be cannot currently find a solve for this. I am currently in a spreadsheet, which has a column that is returning a binary value on the basis of random sampling. I need to l...
BI & Data Analysis
Excel
Formulas and Functions
  • MAngosto's avatar
    MAngosto
    Apr 29, 2024

    Hello pycharge ,

     

    You can simply use the FILTER() function!

    Use FILTER(A1:A50,B1:B50=1)

    Where A1:A50 is the range of item numbers and B1:B50 is the range of the binary values.

MAngosto's avatar
MAngosto
Iron Contributor
Apr 29, 2024

Hello pycharge ,

 

You can simply use the FILTER() function!

Use FILTER(A1:A50,B1:B50=1)

Where A1:A50 is the range of item numbers and B1:B50 is the range of the binary values.

Resources