Nov
05
2010
Incorrect value in Microsoft Excel LOOKUP function
While developing a spreadsheet that used the LOOKUP function I discovered what appears to be a bug (possibly a rounding error) in Excel. Also, as I have not checked on Windows, this is a Mac OSX issue (Snow Leopard at least). Below I present the error and the solution: The Error The LOOKUP function will [...]