J
Jake
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?
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?