Forum Discussion

Anne_Fastre's avatar
Anne_Fastre
Copper Contributor
Jul 19, 2022

Lookup until...

I have a lookup value in a cell on worksheet 2 and would like to lookup all the records on worksheet 1 that match with the lookup value. The values from 2 columns found on worksheet 1 should be liste...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Jul 19, 2022

Anne_Fastre 

This might work. Please update the sheet names and ranges to accommodate your workbook.

 

=FILTER(Sheet1!I2:J1000,Sheet1!A2:A1000=C1)
  • Anne_Fastre's avatar
    Anne_Fastre
    Copper Contributor
    Jul 19, 2022

    Patrick2788 

    This is the result I get 😞

     

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Jul 19, 2022

      A spill error? Try clearing the neighboring cells so FILTER may return the results.