ExcelBanter - Look up function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Look up function (https://www.excelbanter.com/excel-discussion-misc-queries/103049-look-up-function.html)

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"})

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"})