| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up function
Hi,
I am trying to use the look up function, but it seem it does not work. Below is my formula. Can someone help? Thanks. Columm M155 - 132% LOOKUP(M155,{1,0.9,0.8,0.7,0.6,0.5},{"OVERSPENT"," STOP","PROBLEM","LITTLE","WATCH","WITHIN BUDGET"}) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look up function
The lookup vector *must* be in *ascending* order.
Reverse the values in your formula. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "momotaro" wrote in message ... Hi, I am trying to use the look up function, but it seem it does not work. Below is my formula. Can someone help? Thanks. Columm M155 - 132% LOOKUP(M155,{1,0.9,0.8,0.7,0.6,0.5},{"OVERSPENT"," STOP","PROBLEM","LITTLE","WATCH","WITHIN BUDGET"}) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
