Config File value in Vlookup formula

Hi Everyone,

I am trying get the “file path” from the Config file as shown below

I have passed the config value in Vlookup as
the Output came as

Any valuable advice.

Many Thanks in advance


In order to formulas work, the config file has to be open because you are referring the external file.
In the following thread, I made a workflow similar to your requirement. Please check -

1 Like

Hi Karthik,

Thank you for your reply.

Seems need not to open the config file, in order to work on formulas in excel.

But, finally achieved the solution to pass config values into Vlookup formula.

Much appreciated for your help Karthik.


1 Like