BrownBarry
New Member
- Joined
- Sep 3, 2014
- Messages
- 17
Hi I am trying to put a value in a cell by looking up a cell that contains a percentage number.
The formula I am using at the moment is
=LOOKUP(O5,{0,25,50,75},{"1","2","3","4"})
It works on a number cell but not percentage.
Can anyone tell me what the problem is.
Thanks
The formula I am using at the moment is
=LOOKUP(O5,{0,25,50,75},{"1","2","3","4"})
It works on a number cell but not percentage.
Can anyone tell me what the problem is.
Thanks