Could n't apply the proper formula, pls help

In the first worksheet which is basically prepared from the worksheet2. Now in WS1 some information required for descripttion column which is to be captured from ws2 based on type of applicable VAT rate - so i want to get the information relevant at 4% as "Sand stonechip" and 12.5% as "Cement" in WS1 by applying formula. Can you please help me?


Attached File : 11 query.xls downloaded: 145 times
Replies (1)
Use the Pivot Table as shown is the attached file. In case of problem write to excel.expert.13 @ gmail.com PK

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details