Add the target sheet name before the cell reference in the table array, separated by an exclamation mark. This makes the VLookup formula reference the cell range on another sheet. For the example ...

You need four parameters to make it work: the lookup value, the table array ... set or use another function, like INDEX and MATCH, which offers more flexibility. Despite its limitations, VLOOKUP ...

I don't know if the 64-bit versions will resolve the error, but they may introduce their own set of issues. Vlookup used to create an array in memory that held the full range of the table.