Make the vlookup function dynamic for different computers

[Tedishere]

Please see the video below:

I am doing exactly what is being done in the video. The problem I have though is, this will only work on a specific computer because of the directory. What I need to do is transfer both the excel files to many computers. So when I do that and open the file that has vlookup formulas embedded on a different computer, it just says #REF. It is not dynamic. How do I make it so that I would never have to worry about entering/changing formulas on every computer?

 

[Hui]

Your ranges in the Vlookup function need to be made using an Indirect() function
That will allow you to store data like the active directory in a cell and use that as part of the function

Refer: http://forum.chandoo.org/threads/what-is-indirect-function-solved.10688/