Forum Discussion
Solved
Auto populate cell contents when cell in column D equals another cell
I am trying to get it where when someone enters a value in column D that matches M2:M77, then the J cell in that row will automatically pull the corresponding retention text value from column N:2N77.
OliverScheurich Alright, I have another curveball for you if you can help. So, I added the previous formula that is auto-populating the J column now. Now, I have to link another formula to find the K2 estimated date. I need a chain reaction where if J equals retention, "ACT + 3 CY(3 years)" that is auto-filled from the N2:N77 range, then it takes the equivalent amount of months from the O2:O77 range, which for this cell would be 36 months added to F2 cell (04/20/1998) which would then equal 04/20/2001.
I can manually enter the =EDATE(F2,36) Formula, but I have over 10,000 entries to make and I feel that there is some way of marrying or combining the two formulas to auto-fill and generate estimated dates.
=EDATE(F2,INDEX($O$2:$O$77,MATCH(J2,$N$2:$N$77,0)))
This should work if i correctly understand what you are looking for.
- IT WORKED! Thankyou so much
