|
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. |
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 |
| All times are GMT +1. The time now is 08:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com