Range Lookup
 

I want to do something like a vlookup but instead of looking for a specific
number, I want to look for a range and then return a value. An example would
be I want to return a letter grade based on test scores. I have the low end
of the ranges in column A, high end in column B and in this case, the Grade
would be in Column C. How do I do this without having to write a long IF
statement?

Try...

=VLOOKUP(D1,$A$1:$C$10,3,TRUE)

....where D1 contains your lookup value.

Hope this helps!

In article ,
"Jake" wrote:

I want to do something like a vlookup but instead of looking for a specific
number, I want to look for a range and then return a value. An example would
be I want to return a letter grade based on test scores. I have the low end
of the ranges in column A, high end in column B and in this case, the Grade
would be in Column C. How do I do this without having to write a long IF
statement?

Oh - so that's what "True" does. Thanks, I always just typed "False"
automatically...

"Domenic" wrote:

Try...

=VLOOKUP(D1,$A$1:$C$10,3,TRUE)

....where D1 contains your lookup value.

Hope this helps!

In article ,
"Jake" wrote:

I want to do something like a vlookup but instead of looking for a specific
number, I want to look for a range and then return a value. An example would
be I want to return a letter grade based on test scores. I have the low end
of the ranges in column A, high end in column B and in this case, the Grade
would be in Column C. How do I do this without having to write a long IF
statement?