Help with Formula

Question

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

hansvogelaar · Answer

LyndaPM&nbsp;
&nbsp;
=INDEX('Sheet 2'!$K$2:$K$75, MATCH(1, ('Sheet 2'!$D$2:$D$75=B3)*('Sheet 2'!$G$2:$G$75=A3), 0))
&nbsp;
Replace Sheet 2 with the actual name of that sheet.

lyndapm · Answer

It only adds till it finds the person's name which would be the column a and then stops with that person

hansvogelaar · Answer

LyndaPM&nbsp;
Sorry, I don't understand. Can you explain in more detail, preferably with an example?

lyndapm · Answer

Please look at the attached spreadsheet.&nbsp; It stops looking for the lead once it finds them once

hansvogelaar · Answer

LyndaPM&nbsp;
I see what you mean, but I cannot help you with that.

Forum Discussion

Help with Formula

Share

Resources