Enter Values from Specific Month table to my daily sheer use VLOOKUP formula

[itsfaisalkhalid]

Hello Can anyone help me in below attached picture from image 1 is my Data Sheet and 2nd is my daily sheet and i want to auto feel my columns from My DS sheet to daily sheet by month.
EXAMPLE
if i want jul-23 data in daily jul-23 data line which is 3C, in enter Jul-23 in C3, VLOOKUP formula auto look that month from c3 and find the 2 row in DS sheet which mention jul-23 and fill my D3, E3, F3, G3, soo on in my all Rows

 

[awoohaw]

Hi, Mr. Excel has a tool called xl2bb add in (link below) By using this tool the forum does not have to recreate your scenario from scratch to answer your question.
Thanks in advance.

 

[itsfaisalkhalid]

Sale Report July to Dec 2023.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	MAIN DATA	Jul-23		Aug-23		Sep-23		Oct-23		Nov-23		Dec-23
2	BRAND NAME	BRAND NAME	Sale Amount	BRAND NAME	Sale Amount
3	Esen	China PPR	15,056	PPRC Fitting	15,801,997
4	Esen FGRC	HE	193,454	PPRC Pipe	23,555,770
5	UPVC Fitting	IIL-Cash	210,839	T.P Green Water Tank	2,866,943
6	UPVC Pipe	MISC Brands	672,114	T.P Insulation Tape	62,900
7	UPVC Electric	PPRC Fitting	65,646,776	T.P Max Fitting	39,930
8	Siphone Pipe	PPRC Pipe	132,117,399	T.P Tank Plus	668,732
9	PPRC Fitting	Siphone Pipe	90,238	T.P W.T	300
10	PPRC Pipe	T.P Green Water Tank	18,315,374	Turk Cable Duct	795,384
11	PPRC Blue	T.P HD Bore Pipe	1,202,158	Turk Plast (G.P)	172,524
12	PPRC PE Gas	T.P Insulation Tape	1,215,040	Turk Plast WT BM	1,843,747
13	T.P Max Fitting	T.P Max Fitting	(853,080)	UPVC Electric	7,715,560
14	T.P Max Pipe	T.P Max Pipe	(341,813)	UPVC Fitting	10,614,599
15	Manhole	T.P Tank Plus	6,795,159	UPVC Pipe	21,891,242
16	Turk Plast HDPE	T.P W.T	53,551
17	T.P HD Bore Pipe	T.P Water Tank	270,358
18	T.P Green Water Tank	Turk Cable Duct	5,026,058
19	T.P Water Tank	Turk China G.I Fitt	1,234,731
20	T.P Tank Plus	Turk Electric Cable	(4,062)
21	Water Tank Classic	Turk Plast (G.P)	8,226,283
22	Turk Plast WT BM	Turk Plast WT BM	15,281,983
23	Turk Plast (G.P)	TurkPlast Cp Fitting	130,709
24	Turk China G.I Fitt	UPVC Electric	40,092,669
25	BOARING CLASS PIPE	UPVC Fitting	43,576,388
26	CK	UPVC Pipe	135,595,505
27	HE	Water Tank Classic	(7,659)
28	China Fittings
29	lucky
30	ITAP
31	Italy China
32	Kitz Japan
33	Rub China
34	Teflon
35	TG
DS

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B9:B27	Cell Value	duplicates	text	NO

 

[itsfaisalkhalid]

Sale Report July to Dec 2023.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	S #	MONTHS	Esen	Esen FGRC	Turk Plast UPVC		UPVC		UPVC Electric	Siphone Pipe	Turk Plast PPRC		PPRC		Turk Plast PPRC Blue	TPPE (Gas)	T.P.Max		Manhole	Turk Plast HDPE	T.P HD Bore Pipe	TP Water Tank Green	Turk Water Tank Blue	TP Tank Plus	WT Classic	TP WT BM	Turk Plast (G.P)	TURK CHINA G.I FITTINGS	BOARING CLASS PIPE	TOTAL
2	01-Jul				FITTING	PIPE	F%	P%			FITTING	PIPE	F%	P%			FITTING	PIPE
3	1	Jul-23			43,576,388	135,595,505	24	76	40,092,669	90,238	65,646,776	132,117,399	33	67			(853,080)	(341,813)			1,202,158	18,315,374	270,358	6,795,159	(7,659)	15,281,983	8,226,283	1,234,731		467,242,469
4			-		179,171,894						197,764,175						(1,194,893)
5	2	A-23			10,614,599	21,891,242	33	67	7,715,560		15,801,997	23,555,770	40	60			39,930					2,866,943		668,732		1,843,747	172,524			85,171,044
6			-		32,505,841						39,357,766						39,930
7	3	S-23					#VALUE!	#VALUE!	34,895,152	1,083,202	66,249,144	138,392,483	32	68	(8,802)	(2,592)	(64,179)	(40,920)		140,509	401,434	13,967,207	119,283	3,647,215	324,070	11,420,119	3,947,002	1,447,677		275,918,004
8			-		-						204,641,627						(105,099)
9	4	O-23			26,147,356	74,259,078	26	74	27,574,779	84,060	34,360,003	71,531,311	32	68		(35,085)	(46,129)	(18,005)			104,175	10,204,398		4,085,337	(20,935)	7,663,472	3,348,097	772,164		260,014,074
10			-		100,406,434						105,891,314						(64,134)
11	5	N-23			#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!			#REF!	#REF!			#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!	#REF!		-
12			-		-						-						-
13	6	D-23					#VALUE!	#VALUE!					#####	#VALUE!																-
14			-		-						-						-
15			#VALUE!	#VALUE!	#REF!	#REF!			#REF!	1,257,499	#REF!	#REF!			#VALUE!	#VALUE!	#REF!	(400,738)	#VALUE!	#VALUE!	1,707,767	45,353,922	389,641	15,196,442	295,476	36,209,322	15,693,906	3,454,572	-	119,157,809
Daily

Cell Formulas
Range	Formula
D3	D3	=IFERROR(VLOOKUP(DS!A3,DS!B3:C41,2,FALSE),"")
E3	E3	=IFERROR(VLOOKUP(DS!A3,DS!B3:C41,2,FALSE),"")
F3	F3	=IFERROR(VLOOKUP(DS!A5,DS!B3:C41,2,FALSE),"")
G3	G3	=IFERROR(VLOOKUP(DS!A6,DS!B3:C41,2,FALSE),"")
H3,N13,H13,N11,H11,N9,H9,N7,H7,N5,H5,N3	H3	=F3/F4*100
I3,O13,I13,O11,I11,O9,I9,O7,I7,O5,O3	I3	=100-H3
J3	J3	=IFERROR(VLOOKUP(DS!A7,DS!B3:C41,2,FALSE),"")
K3	K3	=IFERROR(VLOOKUP(DS!A8,DS!B3:C41,2,FALSE),"")
L3	L3	=IFERROR(VLOOKUP(DS!A9,DS!B3:C41,2,FALSE),"")
M3	M3	=IFERROR(VLOOKUP(DS!A10,DS!B3:C41,2,FALSE),"")
P3	P3	=IFERROR(VLOOKUP(DS!A11,DS!B3:C41,2,FALSE),"")
Q3	Q3	=IFERROR(VLOOKUP(DS!A12,DS!B3:C41,2,FALSE),"")
R3	R3	=IFERROR(VLOOKUP(DS!A13,DS!B3:C41,2,FALSE),"")
S3	S3	=IFERROR(VLOOKUP(DS!A14,DS!B3:C41,2,FALSE),"")
T3	T3	=IFERROR(VLOOKUP(DS!A15,DS!B3:C41,2,FALSE),"")
U3	U3	=IFERROR(VLOOKUP(DS!A16,DS!B3:C41,2,FALSE),"")
V3	V3	=IFERROR(VLOOKUP(DS!A17,DS!B3:C41,2,FALSE),"")
W3	W3	=IFERROR(VLOOKUP(DS!A18,DS!B3:C41,2,FALSE),"")
X3	X3	=IFERROR(VLOOKUP(DS!A19,DS!B3:C41,2,FALSE),"")
Y3	Y3	=IFERROR(VLOOKUP(DS!A20,DS!B3:C41,2,FALSE),"")
Z3	Z3	=IFERROR(VLOOKUP(DS!A21,DS!B3:C41,2,FALSE),"")
AA3	AA3	=IFERROR(VLOOKUP(DS!A22,DS!B3:C41,2,FALSE),"")
AB3	AB3	=IFERROR(VLOOKUP(DS!A23,DS!B3:C41,2,FALSE),"")
AC3	AC3	=IFERROR(VLOOKUP(DS!A24,DS!B3:C41,2,FALSE),"")
AD3	AD3	=IFERROR(VLOOKUP(DS!A25,DS!B3:C41,2,FALSE),"")
AE3,AE15,AE13,AE11,AE9,AE7,AE5	AE3	=AGGREGATE(9,6,D4,F4,J3:K3,L4,P3:S3,T3:AD3)
D4,L14,F14,D14,L12,F12,D12,R14,R12,R10,L10,F10,D10,R8,L8,F8,D8,R6,L6,F6,D6,R4,L4,F4	D4	=AGGREGATE(9,6,D3,E3)
D5	D5	=IFERROR(VLOOKUP(DS!$A$3,DS!D1:E41,2,FALSE),"")
E5	E5	=IFERROR(VLOOKUP(DS!A4,DS!D1:E41,2,FALSE),"")
F5	F5	=IFERROR(VLOOKUP(DS!A5,DS!D1:E41,2,FALSE),"")
G5	G5	=IFERROR(VLOOKUP(DS!A6,DS!D1:E41,2,FALSE),"")
I5	I5	=G5/F6*100
J5	J5	=IFERROR(VLOOKUP(DS!A7,DS!D1:E41,2,FALSE),"")
K5	K5	=IFERROR(VLOOKUP(DS!A8,DS!D1:E41,2,FALSE),"")
L5	L5	=IFERROR(VLOOKUP(DS!A9,DS!D1:E41,2,FALSE),"")
M5	M5	=IFERROR(VLOOKUP(DS!A10,DS!D1:E41,2,FALSE),"")
P5	P5	=IFERROR(VLOOKUP(DS!A11,DS!D1:E41,2,FALSE),"")
Q5	Q5	=IFERROR(VLOOKUP(DS!A12,DS!D1:E41,2,FALSE),"")
R5	R5	=IFERROR(VLOOKUP(DS!A13,DS!D1:E41,2,FALSE),"")
S5	S5	=IFERROR(VLOOKUP(DS!A14,DS!D1:E41,2,FALSE),"")
T5	T5	=IFERROR(VLOOKUP(DS!A15,DS!D1:E41,2,FALSE),"")
U5	U5	=IFERROR(VLOOKUP(DS!A16,DS!D1:E41,2,FALSE),"")
V5	V5	=IFERROR(VLOOKUP(DS!A17,DS!D1:E41,2,FALSE),"")
W5	W5	=IFERROR(VLOOKUP(DS!A18,DS!D1:E41,2,FALSE),"")
X5	X5	=IFERROR(VLOOKUP(DS!A19,DS!D1:E41,2,FALSE),"")
Y5	Y5	=IFERROR(VLOOKUP(DS!A20,DS!D1:E41,2,FALSE),"")
Z5	Z5	=IFERROR(VLOOKUP(DS!A21,DS!D1:E41,2,FALSE),"")
AA5	AA5	=IFERROR(VLOOKUP(DS!A22,DS!D1:E41,2,FALSE),"")
AB5	AB5	=IFERROR(VLOOKUP(DS!A23,DS!D1:E41,2,FALSE),"")
AC5	AC5	=IFERROR(VLOOKUP(DS!A24,DS!D1:E41,2,FALSE),"")
AD5	AD5	=IFERROR(VLOOKUP(DS!A25,DS!D1:E41,2,FALSE),"")
D7	D7	=IFERROR(VLOOKUP(DS!$A$3,DS!F1:G41,2,FALSE),"")
E7	E7	=IFERROR(VLOOKUP(DS!$A$4,DS!F1:G41,2,FALSE),"")
F7	F7	=IFERROR(VLOOKUP(DS!$A$5,DS!F1:G41,2,FALSE),"")
G7	G7	=IFERROR(VLOOKUP(DS!$A$6,DS!F1:G41,2,FALSE),"")
F11	F11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
G11	G11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
J11	J11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
K11	K11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
L11	L11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
M11	M11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
R11	R11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
S11	S11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
R13	R13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
S13	S13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
V11	V11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
W11	W11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
X11	X11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
Y11	Y11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
Z11	Z11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
AA11	AA11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
AB11	AB11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
AC11	AC11	=VLOOKUP(DS!#REF!,DS!B2:C41,2)
F13	F13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
G13	G13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
J13	J13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
K13	K13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
L13	L13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
M13	M13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
V13	V13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
W13	W13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
X13	X13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
Y13	Y13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
Z13	Z13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
AA13	AA13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
AB13	AB13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
AC13	AC13	=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
T15:U15,P15:R15,L15:M15,J15,D15:G15	D15	=+D11+D9+D7+D5+D3+D13
K15,V15:AD15	K15	=AGGREGATE(9,6,K2:K14)
S15	S15	=AGGREGATE(9,6,S13,S9,S7,S5,S3)