Forum Discussion

Bobby98's avatar
Bobby98
Copper Contributor
Aug 12, 2022

Pulling data from another sheet based on criteria

Hi all

 

I’m trying to set up an Excel sheet that will pull data from one sheet to another based on Criteria.

 

How we currently have it set up is with a Summary that contains all the info then sheets that condense. I’m trying to pull a name from a cell (A2) if the cell in (L2) says laptop. So A2 will be the name of a person and the cell L2 has their kit requirements.

 

If you need any more info please ask

 

thanks all

excel
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Aug 12, 2022

    Bobby98 

    =INDEX(Summary!$A$2:$A$21,MATCH('condense sheet'!B3,Summary!$L$2:$L$21,0))

    You can try this formula for the data layout of the example.

     

    • Bobby98's avatar
      Bobby98
      Copper Contributor
      Aug 12, 2022
      Hi

      When I have typed this out it is just returning a value of 0

      =INDEX(Summary!$A$2:$A$8,MATCH(Laptop!A9,Summary!$L$2:$L:$8,0))

      Any ideas?

      thanks

Resources