In field G9, I've got a data validation list with a source of =IF(F9="Yes",E9,$U$8:$U$19). $U$8:$U$19 is where my list is for the dropdown. If F9=Yes, I want to show the content of E9 in cell G9 and if F9<>"Yes", then I want to provide the dropdown list in G9 to choose from. This is working...sort of. G9 is showing the content of E9 if F9="Yes" but I still have to select it from a dropdown. I want G9 to just show E9 if F9="Yes" without needing to select it from a dropdown. Is this possible?