hello,

I have set up the second variable in a VLOOKUP function (the 'table_array')
to be from another worksheet in the same workbook. In this case, is there a
special syntax for Col_index_num? I entered a ordinary number, as if I would
when referring to data in the same worksheet, and it wouldn't work.

Thanks.

Jeff

Jeff Li wrote:
hello,

I have set up the second variable in a VLOOKUP function (the 'table_array')
to be from another worksheet in the same workbook. In this case, is there a
special syntax for Col_index_num? I entered a ordinary number, as if I would
when referring to data in the same worksheet, and it wouldn't work.

Thanks.

Hi Jeff,

No, there is nothing special about the syntax.

Did you specify table_array with all the columns it needs to fetch
col_index_num?

Hi,

Yes
I　ｈï½�ｖｅ，　ï½�ï½Žï½„ã€€ï½‰ï½”ã€€ï½”ï½•ï ½’ｎｅｄ　ï½�ｕｔ　ｔｈｅ　ï½�ï½’ï½�ｂ ｌｅï½�　ｗï½�ｓ　ｎï½�ｔ　ｂｅｃï½�ï½ •ï½“ｅ　ï½�ï½†ã€€ï½”ï½ˆï½…ã€€ï½†ï½•ï½Žï½ƒï½”ï½‰ï ½�ｎｓ　ｓｙｎｔï½�ｘ，　ｉｔｓ 　ｓï½�ï½�ｅｔｈｉｎｇ　ｅｌｓｅ。

Ｔｈï½�ｎｋｓ　ｆï½�ｒ　ｒｅï½�ï½Œï½”ï½ ™ï½‰ï½Žï½‡ã€€ï½�ｎｙｗï½�ｙ。

Ｊｅｆｆ

"smartin" wrote:

Jeff Li wrote:
hello,

I have set up the second variable in a VLOOKUP function (the 'table_array')
to be from another worksheet in the same workbook. In this case, is there a
special syntax for Col_index_num? I entered a ordinary number, as if I would
when referring to data in the same worksheet, and it wouldn't work.

Thanks.

Hi Jeff,

No, there is nothing special about the syntax.

Did you specify table_array with all the columns it needs to fetch
col_index_num?