Forum Discussion
Matching file names in Excel column to file names in folder
Can you upload a sample file so that we can see what you are trying to achieve?
Does the column have a full path of the file or only file names? Does any column or cell contains the folder path to look for those files?
And if the file is found in the target folder, what do you want to do then? Insert a VLookup Formula referring to those file names in the formula?
A sample file will help to find the answer to the above queries.
Subodh_Tiwari_sktneerHi Thank you for your reply. I'll post a picture and hopefully it can come across clearer. In the example below there are 7 clients with file names in column D and 38 files in the folder. I only need to target the 7 files. The only criteria I have is the file name. What I would do is copy and paste the file name from the spreadsheet into the folder search box. That would work if I were only looking for 7 files by name in a folder with 38 files, but in real life I have many more file names in my spreadsheet and over 1,000 files in the folder. I compared it to VLOOKUP because if the folder were a spreadsheet, I could easily create a column and run the formula to match the files based on the name. Essentially I would want to be able to either highlight the names or somehow extract the files from the large folder. Please let me know if this make sense and if I'm on the right track. Thank you!