PDA

View Full Version : Vloopup in Excel

Surbey
03-19-2007, 04:42 PM
I'm trying to assign grades to number in a workbook. The numerical value is in column C while I want the letter value of the corresponding number in column D. Any idea if I can do this on the page without hardcoding the values somewhere on the sheet? I'm trying to go through the VLookup function and I am having a hardtime understanding what each thing is specifying. Can anyone help me?

Sofaspud
03-19-2007, 05:27 PM
I'm trying to assign grades to number in a workbook. The numerical value is in column C while I want the letter value of the corresponding number in column D. Any idea if I can do this on the page without hardcoding the values somewhere on the sheet? I'm trying to go through the VLookup function and I am having a hardtime understanding what each thing is specifying. Can anyone help me?

VLOOKUP is easier than it looks, actually - once you understand what it's looking for, that is.

VLOOKUP takes 4 arguments, in this format:

VLOOKUP(value_to_find, search_range, column_to_return, match_type)

(I know that's not what Excel calls them, but it's much easier this way.)

value_to_find is what you're looking for in the FIRST column of search_range - in your case, a number value in column C.

search_range is the range in which VLOOKUP will both search and return values from - in your case, C:D (add row numbers if needed).

column_to_return is a number representing which column you want VLOOKUP to pull the value from after it finds value_to_find. Since column D is the 2nd column of your range, you'd use a 2 here.

Finally, match_type specifies HOW you want VLOOKUP to find your results. Using a 0 means "exactly equal to value_to_find" - only the value you specify will qualify. A 1 means "find the closest match you can that is greater than or equal to value_to_find", and -1 means "find the closest match you can that is less than or equal to value_to_find".

So, to wrap up, in your situation you'd probably use something that looks like this:

=VLOOKUP(90, C:D, 2, 0)

You could replace 90 with the address of another cell, for example, instead of a hard-coded value.

Hope this helps!

Surbey
03-19-2007, 11:35 PM
oh very much, thanks!

I actually broke my back testing this out one by one before I saw your post. I figured it out except how to find things that weren't exactly the same. I think I got it now though, thanks alot!