Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which function is use?
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 . ****al Shah |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which function is use?
****al,
This is an ideal candidate for a Pivot Table. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "****al" wrote in message ... 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 . ****al Shah |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which function is use?
Hi
see my post in Excel.worksheet.functions -----Original Message----- 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 . ****al Shah . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |