Looking for a lookup method

[kac1125]

I have two worksheets the first one has item number, Date, and qty

item Number Date Qty 1234 4/24/2024 500

The second sheet has Item number and dates across the top

Item Number	4/22/2024	4/23/2024	4/24/2024	4/25/2024	4/26/2024	4/27/2024
1234

I want to have the qty 500 to show up under the 4/24/2024 date. Please let me know if you have any ideas. Appreciate the support

 

[SanjayGMusafir]

Check this and revert -

Book1
	A	B	C	D	E	F	G
1	item Number	Date	Qty
2	1234	24-Apr	500
3	2345	22-Apr	1
4	4567	26-Apr	2
5
6	Item Number	22-Apr	23-Apr	24-Apr	25-Apr	26-Apr	27-Apr
7	1234			500
Sheet1

Cell Formulas
Range	Formula
B7:G7	B7	=XLOOKUP(1,($A$2:$A$4=$A7)*($B$2:$B$4=B$6),$C$2:$C$4,"",0)

 

[Snakehips]

Might this help?

Book1
	A	B	C
1	Item No.	Date	Qty
2	9999	4/23/24	250
3	1234	4/24/24	66
4	1234	4/24/24	500
5	1234	4/25/24	600
6
Sheet1

Book1
	A	B	C	D	E	F
1	Item No.	4/22/24	4/23/24	4/24/24	4/25/24	4/26/24
2	1234	0	0	566	600	0
3	9999	0	250	0	0	0
4	765	0	0	0	0	0
5
Sheet2

Cell Formulas
Range	Formula
B2:F5	B2	=IF(A2="","",SUMIFS(Sheet1!$C:$C,Sheet1!$B:$B,B$1,Sheet1!$A:$A,$A2))

 

[kac1125]

Check this and revert -

Book1
	A	B	C	D	E	F	G
1	item Number	Date	Qty
2	1234	24-Apr	500
3	2345	22-Apr	1
4	4567	26-Apr	2
5
6	Item Number	22-Apr	23-Apr	24-Apr	25-Apr	26-Apr	27-Apr
7	1234			500
Sheet1

Cell Formulas
Range	Formula
B7:G7	B7	=XLOOKUP(1,($A$2:$A$4=$A7)*($B$2:$B$4=B$6),$C$2:$C$4,"",0)

Thank you for your assistance!

 

[kac1125]

Might this help?

Book1
	A	B	C
1	Item No.	Date	Qty
2	9999	4/23/24	250
3	1234	4/24/24	66
4	1234	4/24/24	500
5	1234	4/25/24	600
6
Sheet1

Book1
	A	B	C	D	E	F
1	Item No.	4/22/24	4/23/24	4/24/24	4/25/24	4/26/24
2	1234	0	0	566	600	0
3	9999	0	250	0	0	0
4	765	0	0	0	0	0
5
Sheet2

Cell Formulas
Range	Formula
B2:F5	B2	=IF(A2="","",SUMIFS(Sheet1!$C:$C,Sheet1!$B:$B,B$1,Sheet1!$A:$A,$A2))

Thank you! This worked perfectly!