Excel query

 

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

Replies (6)
you can use vlook up
Kindly clear with an example.

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details