Forum Discussion
VLOOKUP refuses to look up 1.2x3
I have encountered a very strange error. Let's see if you can reproduce it.
Copy this into a new worksheet and tell you me what you get on row 9
This is what I get:
ps I wasn't actually looking up "1.2x3". I was looking up MROUND(variable+0.6,1.2)
pps for now I'm going to workaround this by adding an IF clause before the VLOOKUP command.
Try
=ROUND(MROUND(number, multiple),1)
It'll work if you enter
=ROUND(1.2*3, 1)
in A9.
