Sorry, I don't understand your description. It took me forEVER to understand
VLOOKUP, so I explain it the way it was taught to me:
http://www.officearticles.com/excel/...soft_excel.htm
And I have a tutorial here that teaches how to use it:
http://www.officearticles.com/tutori...soft_excel.htm
I hope they help.
************
Anne Troy
www.OfficeArticles.com

"BigJDevine" wrote in message
...
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