Default value for drop down list from a different cell in the same row

Question

Good day,I have created a drop down list that has 3 choices but would like to have a default value set based on the contents of another cell in the same row.&nbsp; The contents of the other cell match 1 of the choices in the drop down list. I also need to copy this cell to other cells in the same column to cover multiple rows.&nbsp; Any help would be greatly appreciated.&nbsp; Thanks.Best regards,phdgolf

phdgolf · Accepted Answer

Success. Problem solved. I found out I could just reference the default value in the cell and it does not overlay the drop down list (Cell H5 with drop down list added "=I5"). The drop down list still functions as it should.
Hope everyone has a great week.
Best wishes,
phdgolf

Forum Discussion

Default value for drop down list from a different cell in the same row

Share

Resources