Forum Discussion
How to pull multiple lines from a lookup
This problem has been plaguing me for months and I know there must be some way to do it, but I can't figure out how. I have a relatively large set of data. What I am concerned with are 3 variable...
=IF(SUMPRODUCT(($A$1:A1=A1)*($D$1:D1))<=B1,SUMPRODUCT(($A$1:A1=A1)*($D$1:D1)),"")Is this similar to what you are looking for?
OliverScheurich This definitely gets me a lot closer and will save me a lot of time. Thanks!