I have a dependent data validation list that is created via offset, match and countif. I want to know the formula that will display all the text of the selected range.
Here is an example, with an attached file for review:
This formula check to see
=OFFSET(LC_START_CELL,MATCH($I$3,CONTROL_DC,0),0,COUNTIF(CONTROL_DC,I$3),1)
So in the example below, the user selects Atlanta and then the dependent dropdown list will show all the facility in Atlanta. That part I have done. But what I am looking for is a formula that will automatically populate the facility in a different cell or range.
Here is an example:
Facility State
00715 - GL - BRIARWOOD ATLANTA
00769 - GL - DECATUR ATLANTA
00766 - GL - DUNWOODY ATLANTA
00730 - GL - GLENWOOD ATLANTA
Thank you very much...
Here is an example, with an attached file for review:
This formula check to see
=OFFSET(LC_START_CELL,MATCH($I$3,CONTROL_DC,0),0,COUNTIF(CONTROL_DC,I$3),1)
So in the example below, the user selects Atlanta and then the dependent dropdown list will show all the facility in Atlanta. That part I have done. But what I am looking for is a formula that will automatically populate the facility in a different cell or range.
Here is an example:
Facility State
00715 - GL - BRIARWOOD ATLANTA
00769 - GL - DECATUR ATLANTA
00766 - GL - DUNWOODY ATLANTA
00730 - GL - GLENWOOD ATLANTA
Thank you very much...
