Given are: Columns A and B have values as follows:
A. B. C. D
Cells in column C will have dropdown option values of column A. My objective is that on cell C1, if I choose Chicken from dropdown option, I would like to see 789 on cell D1automatically. That kind of logic.
Thank you guys.