| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handler Not Working | Excel Discussion (Misc queries) | |||
| LOOKUP funciion giving an error | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup Function Error | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
Hybrid Mode
