Forum Discussion
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 s...
=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.
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
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