# Need assistance with Vlook up Formula.

1. ## 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.

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.

3. ## Re: Need assistance with Vlook up Formula.

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.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

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. ## 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.

6. ## 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. ## 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. ## 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.

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

#### 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