Pulling data from another sheet based on criteria

Copper Contributor

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

2 Replies


=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.

condense sheet.JPGsummary.JPG 


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


Any ideas?