Microsoft Excel VLOOKUP Tutorial

haha im naked!!! U

First of all, I wasn't complaining. I was just seeking your advise on what I could have possibly done wrong. Anyway, I understand the problem now. The table array scores needs to be arranged in ascending order from the lowest on top to the highest at the bottom. This wasn't explicitly mentioned though. But thanks for this lesson. I found it useful.

The fourth and last parameter of VLOOKUP is called range_lookup, and that says you need to find an EXACT match in the list. Perhaps you've accidentally specified YES (1) for this parameter? Otherwise, if you followed the lesson EXACTLY as I have it in the video, this should work fine. Thousands of students have taken this class with no complaints.

Hi, i tried practicing what the video has shown. But it doesn't seem to be able to interpret the score range whether it is higher or lower than whats in the 1st column and return the grade.

For example, in your video, a score of 90 or higher gives you an A grade. But when I do it, I put a score of 93, but it returns as #N/A. Unless the score i have is exactly 93. What am i doing wrong? Appreciate your advise.

Fantastic! It's so easy! I have using lots of nested IF statements and getting completely fed up as it can only use 9 at a time. thank you for making it look so simple.

You *could* just use a nested IF statement for this example, but what if you have 50 items to lookup? Your IF statement would be HUGE. Plus, nested IF statements are hard to update, what if the data in your list changes frequently? VLOOKUP is a better solution for larger lists or lists that change often.

Not clear, could have used a Nested IF statement.

Why use a VLOOKUP?

EXCELENT