Hello Ladies and Gents, I am trying to create an automatically filled text box based on the text value of two other cells.
Please see the example below. I have on another sheet two drop down lists, one to select the customer, the second recognises which customer has been selected and then offers the list of customer sites. What I want is for a third cell to recognise the value of the first two and enter the ab, af, bd etc. values.
I can get this to work with continuous lists but not when the data is split up like this.
Please can you help with my problem?
Thanks!
Please see the example below. I have on another sheet two drop down lists, one to select the customer, the second recognises which customer has been selected and then offers the list of customer sites. What I want is for a third cell to recognise the value of the first two and enter the ab, af, bd etc. values.
I can get this to work with continuous lists but not when the data is split up like this.
Please can you help with my problem?
Thanks!
Customer_1 | Customer_2 | ..... | ||
Customer_1_Site_1 | ab | Customer_2_Site_1 | ba | .... |
Customer_1_Site_2 | ac | Customer_2_Site_2 | bb | .... |
Customer_1_Site_3 | ad | Customer_2_Site_3 | bc | ..... |
Customer_1_Site_4 | ae | Customer_2_Site_4 | bd | ..... |
Customer_1_Site_5 | af | Customer_2_Site_5 | be | ..... |
Customer_1_Site_6 | ag | Customer_2_Site_6 | bf | ..... |