+ Reply to Thread
Results 1 to 5 of 5

vlookup question, i think ?

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    vlookup question, i think ?

    I have a working workbook for student score keeping in which attendance is recorded everyday, and teachers use a userform to enter students' score per class. Currently, we teachers have to go to the attendance worksheet to see if a student was marked "excused absence", in which case they get a specific score for the class, rather than the absent score (60). I'd like to add a text box to the userform that displays the names of the students who have been marked "excused" so that we don't have to keep toggling back and forth between sheets, but i can't conceptualize how to do this...

    verbally, it would be something like this:

    if on sheet("attendance"), the column with today's date has an "EA", this text box should have the student's name from column 2 associated with the row the "EA" is in...

    and then it would have to cycle through all 20 rows looking for "EA" for today's date...


    I have never used vlookup before, and i can't seem to find any help on whether or not that would be applicable here.

    thanks for any and all help !!!

    -rob

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: vlookup question, i think ?

    G'day

    A dummy workbook will help us to help you.
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: vlookup question, i think ?

    Can you post a workbook?

  4. #4
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: vlookup question, i think ?

    I can't really post the working workbook, as it is full of names, so I'll see if I can put together a bare-bones example of what i'm looking to do...
    thanks guys !

    -rob

  5. #5
    Registered User
    Join Date
    11-08-2011
    Location
    bergen county, NJ
    MS-Off Ver
    Excel 2007
    Posts
    72

    Re: vlookup question, i think ?

    Here is a dummy workbook...

    thanks guys !

    -rob
    Attached Files Attached Files

+ 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