I am trying to populate a range of cells in a row to reflect a given drop down answer in a specific cell.
For instance, I have a "yes" or "no" gate question in Cell A1. Upon entering "No" in cell A1, I would like cells A2:A10 to populate "N/A". Any help provided is appreciated!
Bookmarks