Location master file in excel

 Blocked Profile -
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

1 reply

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!