Vlookup Function
 

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!

Vlookup Function
 

If your lookup values are not in the leftmost column of the lookup
table, then you can't use VLOOOKUP - however, a combination of INDEX
and MATCH can be used in this situation

Hope this helps.

Pete

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!

Vlookup Function
 

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

Vlookup Function
 

Thanks, Pete!


"Pete_UK" wrote:

If your lookup values are not in the leftmost column of the lookup
table, then you can't use VLOOOKUP - however, a combination of INDEX
and MATCH can be used in this situation

Hope this helps.

Pete

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!

Vlookup Function
 

thanks, Dave! : )
& nice to receive some online resources from you...


"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

Vlookup Function
 

You're welcome.

Pete

Jac wrote:
Thanks, Pete!


"Pete_UK" wrote:

If your lookup values are not in the leftmost column of the lookup
table, then you can't use VLOOOKUP - however, a combination of INDEX
and MATCH can be used in this situation

Hope this helps.

Pete

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!

Vlookup Function
 

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

Vlookup Function
 

If you typed in that address, then try again. The site is there now and both
links work fine for me.

Mandy wrote:

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


--

Dave Peterson