GaryHJones
New Member
- Joined
- Sep 28, 2019
- Messages
- 2
I have been trying to find a solution to my problem, but cant seem to find one.
i have a spreadsheet with names in column A, and events in column B and dates in column C.
the format of the sheet, is like this
Column A Column B Column C
[TABLE="width: 361"]
<colgroup><col width="95" style="width: 71pt;"><col width="173" style="width: 130pt;"><col width="93" style="width: 70pt;"></colgroup><tbody>[TR]
[TD="class: xl67"]Fred Bloggs[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Freestyle[/TD]
[TD="class: xl68, align: center"]09/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Freestyle[/TD]
[TD="class: xl68, align: center"]31/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Freestyle[/TD]
[TD="class: xl68, align: center"]01/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 400 Freestyle[/TD]
[TD="class: xl68, align: center"]21/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 800 Freestyle[/TD]
[TD="class: xl68, align: center"]13/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Breaststroke[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Breaststroke[/TD]
[TD="class: xl68, align: center"]01/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Breaststroke[/TD]
[TD="class: xl68, align: center"]02/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Butterfly[/TD]
[TD="class: xl68, align: center"]21/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Butterfly[/TD]
[TD="class: xl68, align: center"]07/07/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Butterfly[/TD]
[TD="class: xl68, align: center"]03/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Backstroke[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Backstroke[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Backstroke[/TD]
[TD="class: xl68, align: center"]21/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Individual Medley[/TD]
[TD="class: xl68, align: center"]09/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Individual Medley[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl67"]Bill Bob[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Freestyle[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Freestyle[/TD]
[TD="class: xl68, align: center"]23/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Breaststroke[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Butterfly[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Backstroke[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Individual Medley[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
i have a another sheet where i want to be able to select a name from a validated List of Names , and return the correct dates for each of the events listed.
i don't want to have to copy the names down, against the events as there are 100s of names and events.
thanks for any help anyone can give.
i have a spreadsheet with names in column A, and events in column B and dates in column C.
the format of the sheet, is like this
Column A Column B Column C
[TABLE="width: 361"]
<colgroup><col width="95" style="width: 71pt;"><col width="173" style="width: 130pt;"><col width="93" style="width: 70pt;"></colgroup><tbody>[TR]
[TD="class: xl67"]Fred Bloggs[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Freestyle[/TD]
[TD="class: xl68, align: center"]09/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Freestyle[/TD]
[TD="class: xl68, align: center"]31/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Freestyle[/TD]
[TD="class: xl68, align: center"]01/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 400 Freestyle[/TD]
[TD="class: xl68, align: center"]21/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 800 Freestyle[/TD]
[TD="class: xl68, align: center"]13/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Breaststroke[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Breaststroke[/TD]
[TD="class: xl68, align: center"]01/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Breaststroke[/TD]
[TD="class: xl68, align: center"]02/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Butterfly[/TD]
[TD="class: xl68, align: center"]21/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Butterfly[/TD]
[TD="class: xl68, align: center"]07/07/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Butterfly[/TD]
[TD="class: xl68, align: center"]03/02/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Backstroke[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Backstroke[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Backstroke[/TD]
[TD="class: xl68, align: center"]21/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Individual Medley[/TD]
[TD="class: xl68, align: center"]09/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 200 Individual Medley[/TD]
[TD="class: xl68, align: center"]22/09/2019[/TD]
[/TR]
[TR]
[TD="class: xl67"]Bill Bob[/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Freestyle[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Freestyle[/TD]
[TD="class: xl68, align: center"]23/03/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Breaststroke[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Butterfly[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 50 Backstroke[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl69"]1[/TD]
[TD="class: xl66"][/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl67"]Male 100 Individual Medley[/TD]
[TD="class: xl68, align: center"]16/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
i have a another sheet where i want to be able to select a name from a validated List of Names , and return the correct dates for each of the events listed.
i don't want to have to copy the names down, against the events as there are 100s of names and events.
thanks for any help anyone can give.