i have file names as below what i need is if it contains 456 it have to vlookup from master sheet as [TABLE="width: 366"]
C:\Users\123\Desktop\AHK\456.ahk
[/td]C:\Users\123\Desktop\AHK\789.ahk
[/td]C:\Users\123\Desktop\AHK\100.ahk
[/td]C:\Users\123\Desktop\AHK\123.ahk
[/td]C:\Users\123\Desktop\AHK\2021.ahk
[/td]C:\Users\123\Desktop\AHK\2022.ahk
master sheet
[TABLE="width: 500"]
[TABLE="width: 109"]
[TD="class: xl67, width: 109"]Customer Name
[/TABLE]
[TABLE="width: 414"]
[TD="class: xl67, width: 414"]E-mail and cc's
[/TABLE]
[/TD]
[TABLE="width: 320"]
[TD="class: xl67, width: 320"]CC
[/TABLE]
[/TD]
456
[/td][email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[/TABLE]
[/TD]
[/TABLE]