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 [...]

Read the rest of this entry...