Excel query

search in youtube for tutorials and u can use the common head in all the tables as lookup reference

Dear Sir,

Plz find the attachment below on V-LOOKUP, this will be very helpful to you.

use pivot table, with vlookup only one first bill will be shown. To know how to use pivot table. see the balance tab of Downloaded file from here

Hi,

everyone its realy proud movement for me to announce the release of Excel based accounting software package, made by me and my other ca final freinds.

you can download it from here https://sataxsolutions.com/projects.html

We have created 2 packages, one accounting without inventory and one accounting with inventory., It can autocalculate service tax payable , Vat payable TDS receivable, TDS payable.

And its FREE!!!!!!!!!!!!!!!!!!!!!!!!!!!!! 

FOR MORE DETAILS VISIT WWW.SATAXSOLUTIONS.COM

Originally posted by : JMD
	I need to know a formula for a file. In the file two sheets contain one for raw data and second for final partywise letter. There is a partyname, bill no, bill date and amount in first sheet. There may be two or more bills against same party. I need to put a formula in second sheet if party name is same from the data list, it must display all bills  pertaining to that party. I don’t know which formula could be used for the same. So Frnz, kindly guide me if aware of the solution. Looking for reply soon. Regds, JMD

Dear JMD

Vlook up and othre way is SUMIF u can get ur work done with both of this best formulas of excel, it will give u all desired result, more if u need u can send us a sample, I will make it up