How to make a Raffle in Excel | How to Draw a Name From a List Randomly

in this Excel video tutorial we going to see how can we create a raffle and pick a winner through a names list or how can we do a draw from one list of names and pick a winner to do it we can use the randbetween function in Excel and we can also use the vlookup function.

The Randbetween formula in Excel is going to give us a number randomly through a set of values that we can define from a bottom value up to a top value so basically we can define a range and the rand between function is going to draw a number for us.

now with the number of the winner on the screen we can use the vlookup function to bring it back as a result of the name of the winner instead of just to have the number itself so let's say the randbetween function gives to you the number 10 and the vlookup function can look up for the number 10 and bring back the participant name that match with the number 10, that way, you can have both, the number of the winner and also the name of the winner.

#JopaExcel #Dashboard #Excel