Lookup error
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.
|