vlookup from another worksheet
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?
|