Using Google Sheets


A1 contains a value.
B1 has a dropdown menu of associated attributes for A1.
I would like to put a formula in B1 that puts a value from the drop down menu in B1 based on the value in A1.
This way after entering value in A1 the most likely corresponding value is automatically in B2 but, if I want to overwrite it, I can just select a different value from the dropdown.
Is there any way to have a data validation dropdown and a formula in 1 cell? Or a workaround to accomplish something similar.

Thanks!

Shawn