Forum Discussion
Help with Formula
I need a formula for if sheet 2 column d2:d75 matches sheet1 B3, and sheet 2 G2:G75 matches sheet 1 a3, then add corresponding from sheet 2 column k2:k75
It only adds till it finds the person's name which would be the column a and then stops with that person
Sorry, I don't understand. Can you explain in more detail, preferably with an example?
Please look at the attached spreadsheet. It stops looking for the lead once it finds them once
I see what you mean, but I cannot help you with that.