vlookup from another worksheet

[Jeff Li]

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

 

[smartin]

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?

 

[Jeff Li]

Hi,

Yes
I　ｈï½ï½–ｅ，　ï½ï½Žï½„　ｉｔ　ｔｕｒｎｅｄ　ï½ï½•ï½”　ｔｈｅ　ï½ï½’ï½ï½‚ｌｅï½ã€€ï½—ï½ï½“　ｎï½ï½”　ｂｅｃï½ï½•ï½“ｅ　ï½ï½†ã€€ï½”ｈｅ　ｆｕｎｃｔｉï½ï½Žâ€™ï½“　ｓｙｎｔï½ï½˜ï¼Œã€€ï½‰ï½”’ｓ　ｓï½ï½ï½…ｔｈｉｎｇ　ｅｌｓｅ。

Ｔｈï½ï½Žï½‹ï½“　ｆï½ï½’　ｒｅï½ï½Œï½”ｙｉｎｇ　ï½ï½Žï½™ï½—ï½ï½™ã€‚

Ｊｅｆｆ