Lookup error
Could it be the double quotes that you're using (or is that just in the post)???
=LOOKUP(L15,{0,49,50,53,54,56,57,59,60,63,64,66,67 ,69,70,73,74,76,77,79},
{"F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"})
Or could it be that the number of elements in the list of scores doesn't match
the number of elements in the list of grades?
I'm not sure if there should be more grades or fewer scores.
Andmor wrote:
I've developed this lookup using Gord D's formula as a base. I've added in
all the components I need but can't get it to work. Any ideas?
All my data is in column L (as you might have guessed)
=LOOKUP(L15,{0,49,50,53,54,56,57,59,60,63,64,66,67 ,69,70,73,74,76,77,79},{"F","D-",D,D+,"C-","C","C+",B-,"B","B+",A-,A,"A+"})
--
A.
--
Dave Peterson
|