LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
"Pick From List . . . " JP Excel Discussion (Misc queries) 5 February 8th 07 08:55 PM
Lookup using 2 cells as the "X" and "Y" coordinates.... kcsims Excel Worksheet Functions 1 December 15th 06 09:06 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM


All times are GMT +1. The time now is 07:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"