Need help with a Macro that uses VLOOKUP with Application.GetOpenFilename selected file...

I am writing a macro that will allow the user to select a file.

Here is the code I have so far

Please Login or Register  to view this content.

This part works, but what I want to do is use the variable above "tlx_location_file" as part of a vlookup inside of another file which the following code allows the user to pick...

Please Login or Register  to view this content.

Now, here is my problem:

I'm trying to get the macro to use some form of VLOOKUP, where it takes the values in the file above that is the calton_file and looks them up in 2 columns of the tlx_location_file and returns a value to be stored in the same row of the calton_file, column G.

I can't get the right syntax - can anyone help? kind of desperate here!

Well it's hard to give you exact code without more detail (example workbooks showing where the data is and what you want to look up would be helpful) but to use Vlookup in excel you need to define your arguements as ranges, so:

Please Login or Register  to view this content.

Originally Posted by yudlugar

Well it's hard to give you exact code without more detail (example workbooks showing where the data is and what you want to look up would be helpful) but to use Vlookup in excel you need to define your arguements as ranges, so:

Please Login or Register  to view this content.

Thank you - I was able to get it to work a different way. The reason I was having problems was because the "getopenfilename" trick gives the WHOLE filepath in front of the filename itself. This was what was throwing me off.