Forum Discussion

jrchn's avatar
jrchn
Copper Contributor
Feb 13, 2020

Autofill cell based on value of two cells

Hi there , 

 

Im looking to autofill a cell based on a values of two other cells.

 

I currently have two columns

Doctor Name        Doctor Code

Mathew Andres.         M-001

Sara Jaymes.               M-002

 

What I want is that every-time I retype the Doctor Name in a new row it will auto-populate  the 

Doctor Code in that same row. Is it possible to do this in Excel 2019.

 

Thanks in advance

BI & Data Analysis
Formulas and Functions
Macros and VBA

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Feb 13, 2020

    jrchn The answer is Yes!

    You have a variety of functions at your disposal. LOOKUP, VLOOKUP, INDEX combined with MATCH. Your description suggests that a simple VLOOKUP will do what you need, as demonstrated in the attached file.

     

Resources