Forum Discussion
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. ...
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.