donfettuccini, have a look at Create a VLookup formula for a range of values
here

http://www.contextures.com/xlFunctions02.html#Range


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"donfettuccini"
wrote in message
news:donfettuccini.1s2x6t_1121209548.6375@excelfor um-nospam.com...

Hello!

I have a list of 100 names and test scores, then a range of letter
grades.

Name Scores
Joe 100
Billy 95
Max 65
John 49

Grades from100-95, will get a letter Grade A
Grades from 94-80, will get a letter Grade B
79-65, will get a letter Grade C
64-50, will get a letter Grade D
49-0, will get a letter Grade F

I wanted to know if there is a combination of function that will allow
me to convert the scores to their corresponding letter grade. Possible
without macros.


Thanks


--
donfettuccini
------------------------------------------------------------------------
donfettuccini's Profile:
http://www.excelforum.com/member.php...o&userid=25168
View this thread: http://www.excelforum.com/showthread...hreadid=386634