I tried to open this an it said page not found can you help

"Dave Peterson" wrote:

Debra Dalgleish has some very nice notes for =vlookup():
http://www.contextures.com/xlFunctions02.html (for =vlookup())

and if you want to return something that is to the left of the lookup column,
you can use =index(match()).

Debra also has notes:
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Jac wrote:

hi,

Vlookup function needs a parameter named Lookup_value & according to the
description in Function Argument Wizard, it is the value to be found in the
1st column of the table (leftmost column of a table).

The table mentioned above, is it the newly created table or Table_array?
Another thing is this convention a must?
What about the data which are going to look up for are not in the leftmost
column?

Thanks!

--

Dave Peterson