+ Reply to Thread
Results 1 to 3 of 3

Creating a data selection system

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    2

    Creating a data selection system

    Hi All,

    A while ago I saw someone had a workbook where they have two sheets; one contained names, addresses, phone numbers ..etc... The other had a roster. On the first sheet each row (person) had a number assigned to them.

    What they would do is if they wanted to put Jack Jones on the roster, they check sheet one and see his assigned number, type that number in the roster sheet row, and bada-bing, all the data from sheet one goes into the right cells on the roster.

    I need a clue how to get this started.

    Thanks.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Have a look at the vlookup() function in the Help menu ...- F1 - ...
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    01-31-2007
    Posts
    2
    Awesome. Thank you very much.

    I CTRL+B this Forum.

    Elvis

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1