I have a workbook that uses vlookups to return values from another file. What i want to be able to do is change that file based upon the selection from a combo box. i know i have done this is thepast but cant for the life of me remember how i did it.
my current formula is:
i basically want to be able to change the 5+7 part of the file name somehow so it will look at a different file based upon the selection made.