Complex functions like VLOOKUP need better examples. Specifically, all
examples shown use a multi-column cell range reference for the table that
start with a cell in column A, and the 3rd operand is the column number of
the value to be returned. If my range is c5:e18, and I specify the column
number (3rd operand) of 5 (expecting that 5 is the equivalent of column E) I
get a !REF error ... the Function is expecting that the third operand is a
column number relative to the first column in the multi-column cell range
reference (that is, in my example, c=1, d=2, e=3, as opposed to e=5, the
typical case in most cell references). I may have missed that VLOOKUPs 3rd
operand is the "relative" column number, but I don't think so.

----------------
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...et.f unctions