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!

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!

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

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!

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

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!

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

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