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: 7
  • 2.png
    2.png
    27.8 KB · Views: 7

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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
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
1K
felixstraube
F
C
  • Solved
Vlookup & If & SUM Formula
Replies
7
Views
435
Cantrecallmyusername
C
K
  • Question
Formula needed to look up specific name and enter data from specific column within same row
Replies
1
Views
212
awoohaw
awoohaw
A
  • Question
Dynamically add new rows via VBA when using IFERROR TEXTJOIN and FILTER formulas from Table?
Replies
0
Views
148
AlfredDB
A
SaraWitch
  • Solved
VLOOKUP formula with multiple IF statements
Replies
2
Views
500
SaraWitch
SaraWitch

Forum statistics

Threads
1,215,559
Messages
6,125,517
Members
449,236
Latest member
Afua

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