Forum Discussion

DAFLEMING's avatar
DAFLEMING
Copper Contributor
Nov 20, 2023
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...
excel
Excel for web
Formulas and Functions
office 365
  • OliverScheurich's avatar
    OliverScheurich
    Nov 20, 2023

    DAFLEMING 

    =INDEX($N$2:$N$77,MATCH(D2,$M$2:$M$77,0))

     

    This can be done with INDEX and MATCH.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 20, 2023

DAFLEMING 

=INDEX($N$2:$N$77,MATCH(D2,$M$2:$M$77,0))

 

This can be done with INDEX and MATCH.

DAFLEMING's avatar
DAFLEMING
Copper Contributor
Nov 20, 2023
IT WORKED! Thankyou so much

Resources