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

I

itsfaisalkhalid

New Member
Joined
Jun 7, 2023
Messages
3
Office Version
  1. 2019
Platform
  1. Windows
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
 

Attachments

  • 1.png
    1.png
    92.8 KB · Views: 11
  • 2.png
    2.png
    27.8 KB · Views: 10

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
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.
 
Upvote 0
Sale Report July to Dec 2023.xlsx
ABCDEFGHIJKLM
1MAIN DATAJul-23Aug-23Sep-23Oct-23Nov-23Dec-23
2BRAND NAMEBRAND NAMESale AmountBRAND NAMESale Amount
3EsenChina PPR15,056PPRC Fitting15,801,997
4 Esen FGRC HE193,454PPRC Pipe23,555,770
5UPVC FittingIIL-Cash210,839T.P Green Water Tank2,866,943
6UPVC PipeMISC Brands672,114T.P Insulation Tape62,900
7UPVC ElectricPPRC Fitting65,646,776T.P Max Fitting39,930
8Siphone PipePPRC Pipe132,117,399T.P Tank Plus668,732
9PPRC FittingSiphone Pipe90,238T.P W.T300
10PPRC PipeT.P Green Water Tank18,315,374Turk Cable Duct795,384
11PPRC BlueT.P HD Bore Pipe1,202,158Turk Plast (G.P)172,524
12PPRC PE GasT.P Insulation Tape1,215,040Turk Plast WT BM1,843,747
13T.P Max FittingT.P Max Fitting(853,080)UPVC Electric7,715,560
14T.P Max PipeT.P Max Pipe(341,813)UPVC Fitting10,614,599
15 Manhole T.P Tank Plus6,795,159UPVC Pipe21,891,242
16Turk Plast HDPET.P W.T53,551
17T.P HD Bore PipeT.P Water Tank270,358
18T.P Green Water TankTurk Cable Duct5,026,058
19T.P Water TankTurk China G.I Fitt1,234,731
20T.P Tank PlusTurk Electric Cable(4,062)
21Water Tank ClassicTurk Plast (G.P)8,226,283
22Turk Plast WT BMTurk Plast WT BM15,281,983
23Turk Plast (G.P)TurkPlast Cp Fitting130,709
24Turk China G.I FittUPVC Electric40,092,669
25 BOARING CLASS PIPE UPVC Fitting43,576,388
26CKUPVC Pipe135,595,505
27HEWater Tank Classic(7,659)
28China Fittings
29lucky
30ITAP
31Italy China
32Kitz Japan
33Rub China
34Teflon
35TG
DS
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B9:B27Cell ValueduplicatestextNO
 
Upvote 0
Sale Report July to Dec 2023.xlsx
BCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
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
201-Jul FITTING PIPE F% P% FITTING PIPE F% P% FITTING PIPE
31Jul-23 43,576,388135,595,505247640,092,66990,23865,646,776132,117,3993367 (853,080)(341,813) 1,202,15818,315,374270,3586,795,159(7,659)15,281,9838,226,2831,234,731 467,242,469
4-179,171,894197,764,175(1,194,893)
52 A-23 10,614,59921,891,24233677,715,560 15,801,99723,555,7704060 39,930 2,866,943 668,732 1,843,747172,524 85,171,044
6-32,505,84139,357,76639,930
73 S-23 #VALUE!#VALUE!34,895,1521,083,20266,249,144138,392,4833268(8,802)(2,592)(64,179)(40,920)140,509401,43413,967,207119,2833,647,215324,07011,420,1193,947,0021,447,677275,918,004
8--204,641,627(105,099)
94 O-23 26,147,35674,259,078267427,574,77984,06034,360,00371,531,3113268(35,085)(46,129)(18,005)104,17510,204,3984,085,337(20,935)7,663,4723,348,097772,164260,014,074
10-100,406,434105,891,314(64,134)
115 N-23 #REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!-
12----
136 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,76745,353,922389,64115,196,442295,47636,209,32215,693,9063,454,572-119,157,809
Daily
Cell Formulas
RangeFormula
D3D3=IFERROR(VLOOKUP(DS!A3,DS!B3:C41,2,FALSE),"")
E3E3=IFERROR(VLOOKUP(DS!A3,DS!B3:C41,2,FALSE),"")
F3F3=IFERROR(VLOOKUP(DS!A5,DS!B3:C41,2,FALSE),"")
G3G3=IFERROR(VLOOKUP(DS!A6,DS!B3:C41,2,FALSE),"")
H3,N13,H13,N11,H11,N9,H9,N7,H7,N5,H5,N3H3=F3/F4*100
I3,O13,I13,O11,I11,O9,I9,O7,I7,O5,O3I3=100-H3
J3J3=IFERROR(VLOOKUP(DS!A7,DS!B3:C41,2,FALSE),"")
K3K3=IFERROR(VLOOKUP(DS!A8,DS!B3:C41,2,FALSE),"")
L3L3=IFERROR(VLOOKUP(DS!A9,DS!B3:C41,2,FALSE),"")
M3M3=IFERROR(VLOOKUP(DS!A10,DS!B3:C41,2,FALSE),"")
P3P3=IFERROR(VLOOKUP(DS!A11,DS!B3:C41,2,FALSE),"")
Q3Q3=IFERROR(VLOOKUP(DS!A12,DS!B3:C41,2,FALSE),"")
R3R3=IFERROR(VLOOKUP(DS!A13,DS!B3:C41,2,FALSE),"")
S3S3=IFERROR(VLOOKUP(DS!A14,DS!B3:C41,2,FALSE),"")
T3T3=IFERROR(VLOOKUP(DS!A15,DS!B3:C41,2,FALSE),"")
U3U3=IFERROR(VLOOKUP(DS!A16,DS!B3:C41,2,FALSE),"")
V3V3=IFERROR(VLOOKUP(DS!A17,DS!B3:C41,2,FALSE),"")
W3W3=IFERROR(VLOOKUP(DS!A18,DS!B3:C41,2,FALSE),"")
X3X3=IFERROR(VLOOKUP(DS!A19,DS!B3:C41,2,FALSE),"")
Y3Y3=IFERROR(VLOOKUP(DS!A20,DS!B3:C41,2,FALSE),"")
Z3Z3=IFERROR(VLOOKUP(DS!A21,DS!B3:C41,2,FALSE),"")
AA3AA3=IFERROR(VLOOKUP(DS!A22,DS!B3:C41,2,FALSE),"")
AB3AB3=IFERROR(VLOOKUP(DS!A23,DS!B3:C41,2,FALSE),"")
AC3AC3=IFERROR(VLOOKUP(DS!A24,DS!B3:C41,2,FALSE),"")
AD3AD3=IFERROR(VLOOKUP(DS!A25,DS!B3:C41,2,FALSE),"")
AE3,AE15,AE13,AE11,AE9,AE7,AE5AE3=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,F4D4=AGGREGATE(9,6,D3,E3)
D5D5=IFERROR(VLOOKUP(DS!$A$3,DS!D1:E41,2,FALSE),"")
E5E5=IFERROR(VLOOKUP(DS!A4,DS!D1:E41,2,FALSE),"")
F5F5=IFERROR(VLOOKUP(DS!A5,DS!D1:E41,2,FALSE),"")
G5G5=IFERROR(VLOOKUP(DS!A6,DS!D1:E41,2,FALSE),"")
I5I5=G5/F6*100
J5J5=IFERROR(VLOOKUP(DS!A7,DS!D1:E41,2,FALSE),"")
K5K5=IFERROR(VLOOKUP(DS!A8,DS!D1:E41,2,FALSE),"")
L5L5=IFERROR(VLOOKUP(DS!A9,DS!D1:E41,2,FALSE),"")
M5M5=IFERROR(VLOOKUP(DS!A10,DS!D1:E41,2,FALSE),"")
P5P5=IFERROR(VLOOKUP(DS!A11,DS!D1:E41,2,FALSE),"")
Q5Q5=IFERROR(VLOOKUP(DS!A12,DS!D1:E41,2,FALSE),"")
R5R5=IFERROR(VLOOKUP(DS!A13,DS!D1:E41,2,FALSE),"")
S5S5=IFERROR(VLOOKUP(DS!A14,DS!D1:E41,2,FALSE),"")
T5T5=IFERROR(VLOOKUP(DS!A15,DS!D1:E41,2,FALSE),"")
U5U5=IFERROR(VLOOKUP(DS!A16,DS!D1:E41,2,FALSE),"")
V5V5=IFERROR(VLOOKUP(DS!A17,DS!D1:E41,2,FALSE),"")
W5W5=IFERROR(VLOOKUP(DS!A18,DS!D1:E41,2,FALSE),"")
X5X5=IFERROR(VLOOKUP(DS!A19,DS!D1:E41,2,FALSE),"")
Y5Y5=IFERROR(VLOOKUP(DS!A20,DS!D1:E41,2,FALSE),"")
Z5Z5=IFERROR(VLOOKUP(DS!A21,DS!D1:E41,2,FALSE),"")
AA5AA5=IFERROR(VLOOKUP(DS!A22,DS!D1:E41,2,FALSE),"")
AB5AB5=IFERROR(VLOOKUP(DS!A23,DS!D1:E41,2,FALSE),"")
AC5AC5=IFERROR(VLOOKUP(DS!A24,DS!D1:E41,2,FALSE),"")
AD5AD5=IFERROR(VLOOKUP(DS!A25,DS!D1:E41,2,FALSE),"")
D7D7=IFERROR(VLOOKUP(DS!$A$3,DS!F1:G41,2,FALSE),"")
E7E7=IFERROR(VLOOKUP(DS!$A$4,DS!F1:G41,2,FALSE),"")
F7F7=IFERROR(VLOOKUP(DS!$A$5,DS!F1:G41,2,FALSE),"")
G7G7=IFERROR(VLOOKUP(DS!$A$6,DS!F1:G41,2,FALSE),"")
F11F11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
G11G11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
J11J11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
K11K11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
L11L11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
M11M11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
R11R11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
S11S11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
R13R13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
S13S13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
V11V11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
W11W11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
X11X11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
Y11Y11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
Z11Z11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
AA11AA11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
AB11AB11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
AC11AC11=VLOOKUP(DS!#REF!,DS!B2:C41,2)
F13F13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
G13G13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
J13J13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
K13K13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
L13L13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
M13M13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
V13V13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
W13W13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
X13X13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
Y13Y13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
Z13Z13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
AA13AA13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
AB13AB13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
AC13AC13=IFERROR(VLOOKUP(DS!#REF!,DS!D2:E41,2,FALSE),"")
T15:U15,P15:R15,L15:M15,J15,D15:G15D15=+D11+D9+D7+D5+D3+D13
K15,V15:AD15K15=AGGREGATE(9,6,K2:K14)
S15S15=AGGREGATE(9,6,S13,S9,S7,S5,S3)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
How to allocate project hours between specific dates using specific daily hour burn rates and including awkward calendar month start/end+holidays
2
Replies
11
Views
3K
felixstraube
F
C
  • Solved
Vlookup & If & SUM Formula
Replies
7
Views
618
Cantrecallmyusername
C
J
  • Question Question
Using index and match from another source excel file
2
Replies
10
Views
706
Peter_SSs
Peter_SSs
Y
  • Locked
  • Question Question
VLookup or Match or Index: """Trying to figure out how to use formula to enter matching value in a sheet, based on small data from another sheets"""
Replies
1
Views
54
Fluff
Fluff
K
  • Question Question
Formula needed to look up specific name and enter data from specific column within same row
Replies
1
Views
463
awoohaw
awoohaw

Forum statistics

Threads
1,224,744
Messages
6,180,696
Members
452,994
Latest member
Janick

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top