# How to Make Electronic Raffle Draw in Excel (2 Ways)

To select a winner from a lottery, we need to do a raffle draw. Drawing raffles manually is time-consuming and tedious if there are many participants. But this process becomes easier if we do an electronic raffle draw. If we take the help of Microsoft Excel in this regard, this process becomes simpler and more effortless. In this article, we will show you how to make an electronic raffle draw in Excel.

## How to Make Electronic Raffle Draw in Excel: 2 Easy Ways

In our article, you will see two different methods to make an electronic raffle draw in Excel. We will nest the RANDBETWEEN function with the INDEX function in our first method. As for our second approach, we will combine the INDEX function with the MATCH function to make an electronic raffle draw. For our two procedures, we will use the following data set.

### 1. Nesting RANDBETWEEN Function with INDEX Function to Make an Electronic Raffle Draw

In our first approach, we will nest the RANDBETWEEN function with the INDEX function for our working purpose. First, the RANDBETWEEN function will generate a random number from the data set. Then the INDEX function will show the value that is fixed for that random number. For a better understanding, follow the following steps.

Step 1:

• Firstly, we will use the following data set for our procedure.

Step 2:

• Secondly, insert the following nested formula in cell C16 to see the winner.
`=INDEX(C5:C14,RANDBETWEEN(1,10))`

Formula Breakdown

• RANDBETWEEN(1,10): Firstly, The RANDBETWEEN function will generate a random number from 1 to 10. As we have 10 entries in our data set, it will take 1 as the lower limit and 10 as the upper limit.
• INDEX(C5:C14,RANDBETWEEN(1,10)): Then, the INDEX function will show the name that is fixed for the randomly selected number.

Step 3:

• Thirdly, press Enter and you will see a winner’s name randomly selected by applying the above functions.

Step 4:

• Furthermore, by pressing F9 on the keyboard, you can automatically generate more names.

### 2. Combining INDEX and MATCH Functions to Make an Electronic Raffle Draw in Excel

In our second method, we will combine the INDEX function and the MATCH function to make an electronic raffle draw. This method will also include the use of the MAX function and the MIN function of Excel. This method is applicable if you have a set of values assigned to each raffle holder and want to decide the winner based on those values.

#### 2.1 Draw the Maximum Value from Raffle

In this section, we will take the maximum value from the data set to choose the winner. For that purpose, we will insert the MAX function in the combination formula of the INDEX function and the MATCH function. To do that, go through the following steps.

Step 1:

• Firstly, take the data set and make an extra table to announce the winner.

Step 2:

• Secondly, write the following formula in cell C16 to determine the winner.
`=INDEX(C5:C14,MATCH(MAX(D5:D14),D5:D14,0))`

Formula Breakdown

• MAX(D5:D14): The MAX function will find the maximum value from the cell range D5:D14.
• MATCH(MAX(D5:D14),D5:D14,0): Then the MATCH function will search for the location of that maximum value and it will find an exact match.
• INDEX(C5:C14,MATCH(MAX(D5:D14),D5:D14,0)): The INDEX function will get the location range from the MATCH function and the INDEX function will return the name as the result who holds the maximum value.

Step 3:

• Thirdly, hit the Enter button to get the desired result which is Draco.
• Consequently, the result will be based on the lottery number with the highest value in it.

#### 2.2 Draw the Minimum Value from Raffle

If you want to decide the winner based on the minimum value from the list, then this procedure will help you to do that. We will apply the MIN function in the combined formula to see the result. The detailed steps for this procedure are below.

Step 1:

• In the beginning, type the following formula to see the winner in cell C16.
`=INDEX(C5:C14,MATCH(MIN(D5:D14),D5:D14,0))`

Formula Breakdown

• MIN(D5:D14): The MIN function will search for the minimum value in the cell range D5:D14.
• MATCH(MIN(D5:D14),D5:D14,0): Then, the MIN function will find the location of that minimum value and it will find an exact match.
• INDEX(C5:C14,MATCH(MIN(D5:D14),D5:D14,0)): The INDEX function will get the location range from the MATCH function and the INDEX function will return the name as the result who holds the minimum value.

Step 2:

• Secondly, the name of the winner will appear after pressing the Enter button.
• In our example, the winner is Ginny who holds the lowest value of the lottery number.

## Conclusion

Thatâ€™s the end of this article. We hope you find this article helpful. After reading the above description, you will be able to make an electronic raffle draw in Excel automatically by using any of the above-described methods. Please share any further queries or recommendations with us in the comments section below. The Exceldemy team is always concerned about your preferences.

<< Go Back to Random Number in Excel | Randomize in ExcelÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF