I need to perform a vlookup on one sheet to pull numbers from a sheet in another xls file. Additionally, some of the formulas are very long so I need to make sure this uses the relative path instead of the full. Is this possible, and what's the best way to do it.