Random Drawing results

**nickydaewoo** · 06-05-2009, 08:23 PM

Ok so I'm trying to put together a raffle type drawing for my work and I want to display who the winner is in a certain cell. For example

C1:C15 contain random numbers from 1-15, and there are names associated with each one of these numbers in A1:A15. What I want is for D1 to show the name of person in column A that matches up with number 1 in column C. I don't know if that makes any sense or not. I've attached a sample file to see what I'm working with here. Also the numbers in Column C change every time the file is modified. Don't know if that makes a difference or not.

Thanks for your assistance.

**ConneXionLost** · 06-05-2009, 11:28 PM

Hi nickydaewoo,

Welcome to the forum!

This formula will give you the result you asked for:

Please Login or Register  to view this content.

but you'll need to do something about the values generated by the RAND() formula you have in column B. RAND() will recalculate every time the workbook is opened, or when you modify the file, or whenever you press the F9 key.

I suggest you use something like "Edit > Paste Special... > Values" on Column B.

Cheers,

**nickydaewoo** · 06-05-2009, 11:34 PM

Thanks for the help, I actually figured it out just before you posted this. I ended up using a VLOOKUP, and switched some of the columns around. This actually works out for me cause I want it to randomly generate values based on the formula in column B. But thanks for the help.