Ordering random values and texts for a chance-random based TV gameshow.

[Askalian]

Hello,

I have 48 numbers from 1 to 48 in random order (such as : 23 48 12 30 27 22 4 25 10 17 31 33 20 21 46 47 5 36 42 28 11 43 26 35 1 34 29 41 3 9 37 18 44 32 24 13 6 2 16 39 40 15 7 19 8 38 14 45)

The first 12 numbers (23 48 12 30 27 22 4 25 10 17 31 33) are green and should be transformed in "Green"

The 26 following numbers (20 21 46 47 5 36 42 28 11 43 26 35 1 34 29 41 3 9 37 18 44 32 24 13 6 2) are values of 2000$ and should be transfored in "2000"

The 4 following numbers (16 39 40 15) are values of 20,000$ and should be transformed in "20000"
The 3 following numbers (7 19 8) are values of 30,000$ and should be transformed in "30000"
The 2 following numbers (38 14) are values of 50,000$ and should be transformed in "50000"
The last number (45) is a value of 100,000$ and should be transformed in "100000".

So, my question is how can I put the random numbers in correct order, such like this :

2000 - 2000 - 2000 - GREEN - 2000 - 2000 - 30000 - 30000 - 2000 - GREEN - 2000 - GREEN - 2000 - 50000 - 20000 - 20000 - GREEN - 2000 - 30000 - 2000 - 2000 - GREEN - GREEN - 2000 - GREEN - 2000 - GREEN - 2000 - 2000 - GREEN - GREEN - 2000 - GREEN - 2000 - 2000 - 2000 - 2000 - 50000 - 20000 - 20000 - 2000 - 2000 - 2000 - 2000 - 100000 - 2000 - 2000 - GREEN

Well, it is above my competence by far, so thanks for those who can help me for this...
Best.

[mrice]

Are the random numbers in the same cell or same column or same row? Maybe provide a sample workbook?

[Askalian]

The 48 random numbers are in 48 differents cells of the same row. For instance A1 to AV1.
The 48 resulting numbers and texts are in 48 different cells of another row. For instance, A2 to AV2.
Thanks.

[mrice]

Please see the attachment. I have used the HLOOKUP formula to map the values.