List file names in a directory by file explorer

• Go to the specific directory where files are stored.
• Select all files by CNTRL+A.
• Press Shift and Right click on files
• Select “copy as path” from right click menu
• Paste the result in file editor

VLOOKUP - Data Cleansing - MSExcel

 =IF(ISNA(VLOOKUP($B3,G$3:G$26,1,FALSE)), "Not Present", "Present")

=IF(ISNA(VLOOKUP($D3,B$3:B$27,1,FALSE)), "Not Used", "Used")