Forum Discussion
juckto
Mar 05, 2025Copper Contributor
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'...
HansVogelaar
Mar 06, 2025MVP
It'll work if you enter
=ROUND(1.2*3, 1)
in A9.