Require Qty data to other sheets

[Ketan_ashiyani]

Dear Team,

In Total data only fill require Qty data require in other sheet through formula

sample data is below

 

[alansidman]

Cannot manipulate data in a picture. Please use XL2BB to reload the data so we don't have to retype to solv.e

 

[Ketan_ashiyani]

Dear Team,

In Total data only fill require Qty data require in other sheet through formula

sample data is below

View attachment 117762

Pls reply on the ...

 

[Alex Blakenburg]

Alan is trying to explain to you that a picture gives us no data to work with and very little information.
Not only do we manually need to create sample data but the image does not give column or row references or whether the result is on a different sheets.
I also can't tell if you are summing multiple values or whether you just want a straight lookup.

Here is a reference to using XL2BB
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Below are a couple of options that may point you in the right direction:-

20241007 Lookup or Sumifs Ketan_ashiyani.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Sr. No	Product	Product Category	Require Qty			Result -->	Product	Product Category	Require Qty	Sum
2			SGL-1	1					SGL-1	1	1
3			SGL-2	0					SGL-3	2	302
4			SGL-3	2
5			SGL-3	300
6
7
8
Data

Cell Formulas
Range	Formula
J2:J3	J2	=XLOOKUP(I2,$C$2:$C$20,$D$2:$D$20,0)
K2:K3	K2	=SUMIFS($D$2:$D$20,$C$2:$C$20,I2)