Hi everyone, I'm trying to figure out a smarter and more convenient way to sum multiple cells with a fixed lookup value in an extensive sheet. Using a vlookup, or an index-match gives the first value it finds, however, not all values with respect to the specific lookup...
Forum Discussion Share Resources
Rqd. Item Length 4 100 x 133 x 20 5559 1 100 x 133 x 25 5349 1 100 x 133 x 15 2602 2 100 x 133 x 30 2602 2 100 x 133 x 20 5559 2 100 x 133 x 25 5349 7 100 x 133 x 15 2602 2 100 x 133 x 30 2602
I'm trying to figure out a smarter and more convenient way to sum multiple cells with a fixed lookup value in an extensive sheet. Using a vlookup, or an index-match gives the first value it finds, however, not all values with respect to the specific lookup ...
1 100 x 133 x 25 5349 1 4 100 x 133 x 20 5559 1 5349