Spreadsheet: 456881d1461098499-show-list-of-value-in-cell-after-validation-sample
Sheet: Sample

select name to display list
names |  | names |  | cities |  | Customers |  | names
 |  | name1 |  | city 1 |  | cust1 |  | cities
 |  | [NAME] |  | city 2 |  | cust2 |  | customers
 |  | name3 |  | city 3 |  | cust3
 |  | name4 |  | city 4 |  | cust4
 |  | name5 |  | city 5 |  | cust5
 |  | name6 |  | city 6 |  | [NAME]
 |  | name7 |  |  |  | cust7
 |  | name8 |  |  |  | cust8
 |  | name9 |  |  |  | cust9
 |  | name10 |  |  |  | cust10
 |  | name11 |  |  |  | cust11 |  |  |  |  |  | A3
 |  | name12 |  |  |  | cust12 |  |  |  |  |  | "=IF(ROWS(A$3:A3)<=COUNTA(INDIRECT(A$2)),INDIRECT(A$2),"")"
 |  | name13 |  |  |  | cust13
 |  | name14 |  |  |  | cust14
 |  | [NAME] |  |  |  | cust15
 |  | [NAME] |  |  |  | cust16
 |  | name17 |  |  |  | cust17
 |  | name18 |  |  |  | cust18
 |  | name19 |  |  |  | cust19
 |  |  |  |  |  | cust20
 |  |  |  |  |  | cust21
 |  |  |  |  |  | cust22
 |  |  |  |  |  | cust23
 |  |  |  |  |  | cust24
 |  |  |  |  |  | cust25
 |  |  |  |  |  | cust26
 |  |  |  |  |  | cust27
 |  |  |  |  |  | cust28
 |  |  |  |  |  | cust29
 |  |  |  |  |  | cust30
 |  |  |  |  |  | cust31
 |  |  |  |  |  | cust32
 |  |  |  |  |  | cust33
 |  |  |  |  |  | cust34
 |  |  |  |  |  | cust35
 |  |  |  |  |  | cust36
 |  |  |  |  |  | cust37
 |  |  |  |  |  | cust38
 |  |  |  |  |  | cust39
 |  |  |  |  |  | cust40
 |  |  |  |  |  | cust41
 |  |  |  |  |  | cust42
 |  |  |  |  |  | cust43
 |  |  |  |  |  | cust44
 |  |  |  |  |  | cust45
 |  |  |  |  |  | cust46
 |  |  |  |  |  | cust47
 |  |  |  |  |  | cust48
 |  |  |  |  |  | cust49
 |  |  |  |  |  | cust50
 |  |  |  |  |  | cust51
 |  |  |  |  |  | cust52
 |  |  |  |  |  | cust53
 |  |  |  |  |  | cust54
 |  |  |  |  |  | cust55
 |  |  |  |  |  | cust56
 |  |  |  |  |  | cust57
 |  |  |  |  |  | cust58
 |  |  |  |  |  | cust59
 |  |  |  |  |  | cust60
 |  |  |  |  |  | cust61
 |  |  |  |  |  | cust62
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust65
 |  |  |  |  |  | cust66
 |  |  |  |  |  | cust67
 |  |  |  |  |  | cust68
 |  |  |  |  |  | cust69
 |  |  |  |  |  | cust70
 |  |  |  |  |  | cust71
 |  |  |  |  |  | cust72
 |  |  |  |  |  | cust73
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust75
 |  |  |  |  |  | cust76
 |  |  |  |  |  | cust77
 |  |  |  |  |  | cust78
 |  |  |  |  |  | cust79
 |  |  |  |  |  | cust80
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust82
 |  |  |  |  |  | cust83
 |  |  |  |  |  | cust84
 |  |  |  |  |  | cust85
 |  |  |  |  |  | cust86
 |  |  |  |  |  | cust87
 |  |  |  |  |  | cust88
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust90
 |  |  |  |  |  | cust91
 |  |  |  |  |  | cust92
 |  |  |  |  |  | cust93
 |  |  |  |  |  | cust94
 |  |  |  |  |  | cust95
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust97
 |  |  |  |  |  | cust98
 |  |  |  |  |  | cust99
 |  |  |  |  |  | cust100
 |  |  |  |  |  | cust101
 |  |  |  |  |  | cust102
 |  |  |  |  |  | cust103
 |  |  |  |  |  | cust104
 |  |  |  |  |  | cust105
 |  |  |  |  |  | cust106
 |  |  |  |  |  | cust107
 |  |  |  |  |  | cust108
 |  |  |  |  |  | cust109
 |  |  |  |  |  | cust110
 |  |  |  |  |  | cust111
 |  |  |  |  |  | cust112
 |  |  |  |  |  | cust113
 |  |  |  |  |  | cust114
 |  |  |  |  |  | cust115
 |  |  |  |  |  | cust116
 |  |  |  |  |  | cust117
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust119
 |  |  |  |  |  | cust120
 |  |  |  |  |  | cust121
 |  |  |  |  |  | cust122
 |  |  |  |  |  | cust123
 |  |  |  |  |  | cust124
 |  |  |  |  |  | cust125
 |  |  |  |  |  | cust126
 |  |  |  |  |  | cust127
 |  |  |  |  |  | cust128
 |  |  |  |  |  | cust129
 |  |  |  |  |  | cust130
 |  |  |  |  |  | cust131
 |  |  |  |  |  | cust132
 |  |  |  |  |  | cust133
 |  |  |  |  |  | cust134
 |  |  |  |  |  | cust135
 |  |  |  |  |  | cust136
 |  |  |  |  |  | cust137
 |  |  |  |  |  | cust138
 |  |  |  |  |  | cust139
 |  |  |  |  |  | cust140
 |  |  |  |  |  | cust141
 |  |  |  |  |  | cust142
 |  |  |  |  |  | cust143
 |  |  |  |  |  | cust144
 |  |  |  |  |  | cust145
 |  |  |  |  |  | cust146
 |  |  |  |  |  | cust147
 |  |  |  |  |  | cust148
 |  |  |  |  |  | cust149
 |  |  |  |  |  | cust150
 |  |  |  |  |  | cust151
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | cust153
 |  |  |  |  |  | cust154