Dynamic Input file and vlookup

[gavinloi]

Hi all,

Currently on a daily basis, i would have an excel with different dates  on it and currently i am trying to solve this error as even if i use (*) to make the file path dynamic it generates an error. My workflow would be that it takes 2 different excel files (1 static) and (1 dynamic) before creating a new column and doing a vlookup. Would there be any way to solve this dynamic path ?

Thanks!

[gavinloi]

Hi both,

Many thanks! its working fine now due to the line that the data is picking it up from.

attaching the csv file for ref as well.

Really appreciate the help on this! 🙂

[atcodedog05]

Hi @gavinloi 

Just to confirm, your issue is resolved right. Or do you have some followup issue ?

If its resolved can you mark mine and @Qiu posts which was helpful as solution. So that its helpful other to know its resolved.

Happy to help 🙂

[gavinloi]

Thanks both @Qiu @atcodedog05 

have accepted it as solutions as well. 🙂

[Qiu]

@atcodedog05 
Thank you for always thinking about me 😁

@gavinloi 
Glad to help and thank you for the accept mark.