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