There is a problem with the Excel LOOKUP function that I would like to have
fixed. It doesn't appear to work with real numbers correctly. I set up a
column of fractional numbers and and used LOOKUP to find the MAX value of the
list. It works occasionally and only for certain positions in the table. I
wish I could attach my sheet but I think it is easy to understand what I have
done.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc