Hi all, I have a spreadsheet in which I need a dropdown list cell's value to change based upon the value in another dropdown list cell. Cell H4 is a dropdown list created by way of the Data Validation button and can only contain "Y" of "N" values. Cell C15 is also a dropdown list created by way of the Data Validation button. Cell H4 will be entered first and then cell C15 will be entered. What I need is this, when a value is selected from the dropdown list in cell C15, then the value of cell H4 will change accordingly. For example, if "48g PET" is selected from the dropdown list in C15, then the value should be set in H4 to "Y", or for example in the opposite side, if "50t PET" is selected from the dropdown list in C15, then the value should be set in cell H4 to "N". There are 7 avaliable selections in the dropdown list in C15 and each value should set the value in H4 to either "Y" or "N". Can anybody give me an easy way to accomplish this?
Thank you!
Bookmarks