Editing a table that is related to ranges

economistegypt2010

New member
Joined
Nov 22, 2014
Messages
2
Reaction score
0
Points
0
The attached file includes a table that includes 2 sheets. The first sheet includes ranges. The second one includes drop down list realted to these ranges. I just wanted to know how to edit in this table or to fill out the data in the table.

Example:
The customer base in Suez is 15%. NPS is 12%. Market share is 47%
The customer base in Cairo is 85%. NPS is 42%. Market share is 87%

How can I put these inputs into the table where when I choose Cairo form the drop down menue these details "The customer base in Suez is 15%. NPS is 12%. Market share is 47%" appear to me.
 

Attachments

  • 360561d1416671698-creating-a-complicated-table-book1 (1).xlsx
    9.6 KB · Views: 10
Pl find attached file. I hope it will help you.
 

Attachments

  • 360561d1416671698-creating-a-complicated-table-book1%20(1)(1).xlsx
    11.2 KB · Views: 4
Back
Top