I will be happy if someone can help me with Vlookup functionality. I have used VLOOKUP before but unable to fix this one on my own.
What I'm trying to do is code a macro and use vlookup to get data from different file names specified in column "C". For eq: there is a file called "Asia.xls" and the word "Asia" is stored in column location R14C3.
I tried the following code to append the filename to the filepath but it didn't work.
Please let me know if I'm unclear.