Which function is use?

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

I have 2 data sheet.
IN sheet1
Name of co., Product Name, Qty, Month,
D & Q Pen 100 April
PRG Pen 100 April
D & Q Ink 550 April
D & Q Ink 400 April
D & Q Pen 100 April
PRG Ink 100 May
D & Q Ink 300 May
D & Q Pen 100 May
PRG Ink 200 May

IN Sheet2

NAME OF CO
.. /PRODUCT, PEN, INK
D & Q 5 2
PRG 3 4

With this 2 sheet I want to out like

Name of co. D & Q
Product Name April May Total
Pen 200 100 300
Ink 950 300 1250

Now I want to lookup & match name of co. & product name
with this data total & multiply D & Q with PEN 5 that is
300 * 5 = 1500 and D & Q with INK 2 that is
1250 * 2 = 2500

I have try with advance filter & Index, Match function but
some how I am not able to do it is any help .

Shital Shah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which Fuction is use? 1
Altering Paste Data 2
which function use? 1
which function is use? 2
Moving data from one sheet to a template, matching numbers 3
Count Function 2
Count partial matched text string 4
how i maintain stock ? 2

Back
Top