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