Reference this cell or that cell to display area

asked 2021-03-11 20:59:56 +0200

Nacho-Libre gravatar image

updated 2021-06-11 07:07:08 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive close merge delete