Hi
I'm using LOOKUP to allocate codes to numbers.
=LOOKUP(H12,{0,1,30,40,50,60,70,80},{0,1,2,3,4,5,6,7})
This returns e.g. 50 as 4
However the focus cell is formatted to round up and I would like LOOKUP to recognise the displayed rounded number rather than the actual value.
e.g. 49.5 displays as 50. I would like this to return 4, rather than 3.
At the moment this is my workaround:
= LOOKUP(H12,{0,0.5,29.5,39.5,49.5,59.5,69.5,79.5},{0,1,2,3,4,5,6,7})
It works, however I wonder if there is a better more modular solution?
Bookmarks