+ Reply to Thread
Results 1 to 4 of 4

Formula to search for data

  1. #1
    Registered User
    Join Date
    10-13-2006
    Posts
    2

    Formula to search for data

    I have a sheet with a list of some of our computer user names and other various info. I have another sheet that has ALL user names and email address'. I am trying to get the email address' filled in for the select users on the first sheet. What I need if possible is a way for the first sheet to search the second sheet for the username and fill in the associated email address on the first sheet.

    Is this asking to much or do I just have to do it manually?
    Thanks,

  2. #2
    Registered User
    Join Date
    10-13-2006
    Posts
    3
    Use a vlookup function

  3. #3
    Registered User
    Join Date
    07-27-2006
    MS-Off Ver
    MS Office 2007
    Posts
    79
    yes... vlookup should work for you
    TL

    https://sites.google.com/site/teelim/
    My page of "not so useful" spreadsheets

  4. #4
    Registered User
    Join Date
    10-13-2006
    Posts
    2
    Thanks so much, I did not know about the Vlookup.

    It worked PERFECTLY!!


    Thanks again

+ 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