Dear All,
Some of you will be using TALLY and may use the option of exporting some data as a EXCEL WORKSHEET.
REQUIREMENT:
A worksheet containing party’s names and outstanding amounts is exported from TALLY. The name of the parties and their mobile phone number is available with me in another worksheet called PHONE.
The data exported from TALLY is placed in the columns A to G. Now I want a simple formula that could fetch the mobile number of these parties in column H.
Problems: 1. The PHONE worksheet may not contain phone numbers for a few parties. 2. The name of parties may not be in alphabetical order in the worksheet exported by Tally as well in my PHONE worksheet.
Imagine that you have around 4000 cllients. Will it be possible to switch to PHONE worksheet and use the FIND option to find the mobile number of the party as and when required?
The INDEX & MATCH function in Excel offers a very simple solution. If you are interested to know how, please send a mail to geta.erode@gmail.com. We will send a sample worksheet.
Regards,
Team GLOBALedge.
Yes ! Tally provides very useful tool of import and export of data . Ofcourse with this , we can see the full detail of our debtors and creditor by exporting data from tally to excel sheet .