Config File value in Vlookup formula


#1

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
vlook
the Output came as

Any valuable advice.

Many Thanks in advance

Regards
Vishnu


#2

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 -


#3

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.

Regards
Vishnu