Hi,

I am having difficulty using Vlookup in VBA to return a value from a workbook on a workspace folder.

First off, is this even possible? I tried using variables because the standard Vlookup wasn't working but still kept getting compile errors.

Any ideas on how to approach this?