I have a group of cells that I have named “City” and I have another group of cells I have named “County” I am trying to display the cells of “City” in the cells of “State” by referencing the text in other cells.
For example: If cells B1, B3, or B7 have “State” in the cell then group “County” should display the cells of “City”
I could use "=IF(B1=State,C7(B3=State,C7)) for each individual cell but this would be very time consuming doing it this way. Anyone have any suggestions?