I have a set of four columns of data. I'd like to create a formula that can look at an input from data in column 1 to pick data point(s) from the corresponding row(s) in column 2 and multiply it by data point(s) from the corresponding row(s) in column 3.
I think I could solve this by creating a vlookup for column 2 and multiplying by the result of another vlookup for the column 3, but their might be several rows that match the input in column 1, and I would like the sum of all those matches.
Kind of hard to explain, so I've included an attachment with samples of what I would like the input to be (looking at data in column 1) and what the output to be (multiplying matches in column 2 and column3).
Any help or advice is greatly appreciated!
Bookmarks