Using Variable within Vlookup Formula

I'm trying to use a variable to represent a workbook in a Vlookup formula. While it is on the sheet I define the variable as the activeworkbook. Later in the macro, while in a different sheet, I'm trying to refer back to this sheet.

The Vlookup equation looks like this:

Please Login or Register  to view this content.

I can't get this substitution to work. Any help?

Please Login or Register  to view this content.

I also tried this:

Please Login or Register  to view this content.

You might need to use the INDIRECT reference formula