+ Reply to Thread
Results 1 to 8 of 8

Need assistance with Vlook up Formula.

  1. #1
    Registered User
    Join Date
    05-17-2020
    Location
    London
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Need assistance with Vlook up Formula.

    Question 1:
    Springfield University has over 5,000 students. Each student is assigned a four-letter Status, which is either UNCL (unclassified), UGRD (undergraduate), or GRAD (graduate). The first digit of the student number reflects the four-letter Status:
    If the first digit of the student number is 1 or 2, then the Status is UNCL.
    If the first digit of the student number is 3, 4, or 5, then the Status is UGRD.
    If the first digit of the student number is 6, 7, 8, or 9, then the Status is GRAD.
    No student has a student number beginning with the number 0. Furthermore, each student number consists of exactly six digits. Assume for the purposes of the following three questions, and for simplicity, that a student cannot change Status.

    Professor Grey is an instructor of COMM 499, an undergraduate course at the Faculty of Commerce at Springfield U that is open to all students regardless of their status. This means that even students with GRAD and UNCL status (in addition to those with UGRD status) are allowed to take the course. The grading system used for UNCL and UGRD students, however, is different from the grading system used for GRAD students.

    First, Professor Grey needs to complete column B of his class list (in an Excel spreadsheet) to assign each student to the correct four-letter Status. He wants to use a VLOOKUP function. Professor Grey intends to type up the formula in cell B2, and then drag the formula down to cell B15. The lookup table will be in F3:G5.

    Complete the lookup table F3:G5.

    Question 2:
    Assume that Professor Grey has completed the lookup table F3:G5 correctly.

    Recall that Professor Grey needs to complete column B of his class list (in an Excel spreadsheet) to assign each student to the correct four-letter Status. He wants to use a VLOOKUP function. Professor Grey intends to type up the formula in cell B2, and then drag the formula down to cell B15.

    Complete the formula in cell B2. Remember that the formula, when dragged down to cell B15, must work automatically without the need to manually edit it.

    Question 3:

    Now, Professor Grey wants to assign the letter grade for each student in his class. If the student is an undergraduate or an unclassified student, s/he will receive a letter grade based on the table I3:J13. If the student is a graduate student, s/he will receive a letter grade based on the table L3:M12.

    The threshold is the minimum percent grade required to attain the corresponding letter grade.

    Complete the following formula in cell D2. The formula must work properly when dragged down to cell D15, and it must not be changed manually.
    Attached Files Attached Files
    Last edited by fahadferoz01; 05-17-2020 at 04:17 AM. Reason: admin post

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,088

    Re: Please help me with these 3 vlook up problems. Excel Sheet is attached.

    Tell us what you have tried - we won't do your homework assignments for you.

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,269

    Re: Need assistance with Vlook up Formula.

    crossposted: https://chandoo.org/forum/threads/pl...ttached.44308/

    https://www.mrexcel.com/board/thread...ached.1134346/

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Last edited by alansidman; 05-17-2020 at 04:29 AM.

  4. #4
    Registered User
    Join Date
    05-17-2020
    Location
    London
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Re: Please help me with these 3 vlook up problems. Excel Sheet is attached.

    Stop stalking me everywhere. would be glad if you delete my post (if you are moderator) or stop following me. Casue you do not have any intention to help me.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,088

    Re: Need assistance with Vlook up Formula.

    No, you are wrong: I will help you, but I will not simply give you a solution, which seems to be what you want.

    If you are not prepared to make an effort on what is clearly an assignment, not even to tell us what your initial thoughts were about solving the problems posed, then I can't in all conscience give you any guidance. I am a teacher by profession, so I am certainly not going to help you to cheat.
    Last edited by AliGW; 05-17-2020 at 04:48 AM.

  6. #6
    Registered User
    Join Date
    05-17-2020
    Location
    London
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Re: Need assistance with Vlook up Formula.

    stop being self pretentious. i am not bound to take help from you and you are not going to help me (thats obvious from those harsh statements you made). i am not a student and no cheating is involved here. if you dont want to help dont spread such poisonous thoughts on others. you are not a good human. And if you are a teacher as you are claiming (which i dont believe) your students must be in grave problem.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,088

    Re: Need assistance with Vlook up Formula.

    Well, I am a teacher - I have been for 30 years.

    So, if this is not an assignment, where did you get it from? It's clearly some sort of practice exercise. Just be honest - and as I said, if you want help, tell us what you have considered. Unless we know that, we can't help you without simply handing you solutions on a plate.

    So, if it's not an assignment, why are you doing a practice exercise that you don't even want to try working out? What do you want from us?

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Need assistance with Vlook up Formula.

    if you dont want to help dont spread such poisonous thoughts on others. you are not a good human.
    Stop stalking me everywhere. would be glad if you delete my post (if you are moderator) or stop following me. Casue you do not have any intention to help me.
    What a rude words for someone, who wants help other forummember(s).

    I am no moderator, but if you don't want any help any more;
    you can mark the question solved.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Switch from attached excel sheet to two matrices = one pair and one odd.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2017, 02:09 PM
  2. Replies: 10
    Last Post: 12-24-2016, 04:43 PM
  3. Replies: 6
    Last Post: 11-12-2016, 06:48 PM
  4. Date Problem-See attached Excel Sheet
    By Goldenone in forum Excel General
    Replies: 3
    Last Post: 11-15-2014, 09:41 PM
  5. Replies: 0
    Last Post: 11-28-2013, 06:06 AM
  6. Convert multiple column to excel sheet attached
    By ahad_bwp in forum Excel General
    Replies: 2
    Last Post: 07-11-2012, 09:04 AM
  7. vlook up problems need sort?
    By mws5872 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2006, 12:43 PM

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