+ Reply to Thread
Results 1 to 4 of 4

Issue with VLook Up and data matching

  1. #1
    Registered User
    Join Date
    12-02-2019
    Location
    scotch plains
    MS-Off Ver
    2010
    Posts
    5

    Issue with VLook Up and data matching

    Hi All,

    I am struggling to find out a formula to run through my spreadsheet. I am attaching a sample excel sheet. In my first sheet, i want if my student ID has taken Maths/science/physics etc. class or not. There is a reference sheet which shows students have enrolled for which class.

    I guess, i am struglling to figure out how to show the data in yes and no in the first sheet.


    Thanks,
    Abhishek
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Issue with VLook Up and data matching

    Take the " (Y/N)" off the headings and try

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag across and down.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    12-02-2019
    Location
    scotch plains
    MS-Off Ver
    2010
    Posts
    5

    Re: Issue with VLook Up and data matching

    Thank you! Works great!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Issue with VLook Up and data matching

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOK UP Issue - Works on some cells, but not on others!
    By champaben in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-10-2016, 10:41 AM
  2. simple vlook up issue...cannot figure out
    By putitwhere in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:25 PM
  3. [SOLVED] Vlook up and #N/A issue
    By Markarmi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 12:02 PM
  4. Vlook up issue
    By ashinSydney in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-13-2013, 10:39 AM
  5. Issue looking up Matching data
    By danison in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-05-2008, 09:54 PM
  6. Vlook up issue
    By toronto747 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2007, 06:12 AM
  7. Vlook up for matching data in two seperate sheets
    By funky via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 06:05 PM

Tags for this Thread

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