Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Would I use "Lookup" to pick names for a Christmas grab bag
Hi,
I am trying to create (what I thought was a small project) a Christmas Grab Bag, sort of speak. A person would type in his/her name and then the computer would randomly pick out one name of the people in the grab bag. I am trying to use vlookup but I don't know how to have the computer only pick the name once, with out using his/her own name. Does anyone have any ideas???? Below is an example of what I am trying to do. Joe Mary Bob Jane Enter your name: Joe You Have: Bob Is this way beyond something for excel??? It's way beyond me. I thought it would work but I can't seem to find any functions to make this turn out. Can someone please help????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"Pick From List . . . " | Excel Discussion (Misc queries) | |||
Lookup using 2 cells as the "X" and "Y" coordinates.... | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |