I have a directory
within this directory is a certain number of files that increases or decreases
I want to use a vlookup to look for data.
The issue is that the number of files can increase or decrease.
Can code be used to look at the number of files and use the vlookup on those files?
I am not looking for vlookup formula because i do know this already. I am only interested in applying the vlookup code to ever changing number of files in this directory.