Aug 12 2022 06:18 AM
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
Aug 12 2022 06:28 AM
=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.
Aug 12 2022 07:09 AM