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.

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.

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.

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.

Download Practice Workbook

You can download the free Excel workbook here and practice on your own.

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