Is concatenate what I need?

[Neil Grantham]

I want to create a text string from various cells, but the order of
the string must be the result of a checking another cell.

For example:
My cells
A B C
1 62.4 John Smith 2
2 Fred Bloggs 3
3 Brian West 0
4 John Ford 1

My text string should check the order (3,2,1,0) to give
Fred Bloggs, John Smith, John Ford, Brian West, 62.4
(3 point for a win, 2 for 2nd, 1 for 3rd, 0 for 4th)

Is this possible? Do I use concatenate?
Suggestions most welcome,

Thanks in advance
Neil

 

[Jerry W. Lewis]

=INDEX(B1:B4,MATCH(3,C1:C4,0))&", "&INDEX(B1:B4,MATCH(2,C1:C4,0))&",
"&INDEX(B1:B4,MATCH(1,C1:C4,0))&", "&INDEX(B1:B4,MATCH(0,C1:C4,0))&", "&A1

CONCATENATE does not permit array arguments, or it might be possible to
streamline this considerably.

Jerry

 

[Neil Grantham]

Thanks Jerry,
What I actually need to evaluate is more complicated
This is the result of a motorcycle race, where a rider may be replaced
by a reserve if he falls for example.
So the actual match program might look like
A B C D E
1 Time Name Reserve Result
2 61.1 John FX Ole 1
3 Fred 3
4 Brian 2
5 Joe F

So, I want to put this into one string, which would look like this,
when 3 is the winners points, 2 for second, 1 for 3rd, 0 for 4th.
(F/FX denote non finishers who need to be included):

Fred, Brian, Ole, Joe (F), John (FX), 61.1

Is that possible using INDEX? or do I need some other method?

Thanks to anyone who can suggest an answer

Neil.