Lottery Wheel

[Firedog]

Hello,

I am a new member, but a long time reader and I have watched many of your videos. I am trying to make a Lottery Wheel that used 20 numbers to get 36 combinations. I have attached a sample pic of what I need the formulas to do. I tried to attach the excel file, but was not able to do so. The number in B5, will automatically be placed in the correct cells, B9:B17, with the corresponding letter. I need this to work for all of the 20 numbers in cells B5:K5, and B7:K7. Thanks you for the assistance.

 

[jkpieterse]

There also isn't a picture in your post I'm afraid.

 

[Firedog]

Hello,

I am a new member, but a long time reader and I have watched many of your videos. I am trying to make a Lottery Wheel that used 20 numbers to get 36 combinations. I have attached a sample pic of what I need the formulas to do. I tried to attach the excel file, but was not able to do so. The number in B5, will automatically be placed in the correct cells, B9:B17, with the corresponding letter. I need this to work for all of the 20 numbers in cells B5:K5, and B7:K7. Thanks you for the assistance.