Location master file in excel [Solved/Closed]

Ask a question Param - Last answered on May 24, 2016 at 06:40 PM by ac3mark
I have location master file in excel.

1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi,

2) i want to bring Ashok vihar in A4 column if it is in my master file

only i have to pick Ashok Vihar

which formula i have to insert

please help with example in excel sheet
plus moins
You are talking about ADO, or OLE. Those technologies are above the scope of these forums. Although it is possible, it can be rather cumbersome to open a remote (even local to the computer) file if you are not familiar with these type of operations. We are sorry, but projects such as these cannot be addressed.

We appreciate you understanding, and if you get stuck, you know you can come here with some code and we will help!

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!