Best formula for data lookup from Store#, Dept #, and Date from a lot of data

KLund1

Board Regular
Joined
Oct 27, 2005
Messages
64
I have a sheet of sales with 7 blocks of daily data, Sunday to Sat. one block for each day. They are by store, down, and dept, across.
I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of sales into each of the store tabs by day of the week, and dept.
I think it should be some type of V/H-LOOKUp formula but am lost on how to build it. Or it might be an Offset formula. I am toally not sure what to do.
Below I posted some test data sheets like what I will be using. The file names will need to be change to real ones later.
I not yet have rights to add file attachments here.
After the Sheets of sales is a test report from one of the Store report tabs. There are some notes in the first 2 days to see what I ma looking for.
I hope am I clear about what I need. If not please ask me anything.
Many thanks!!


File name is Sheets of sales Sunday Test data
STORE 1 2 3 4 5 6
3 $361.00 $719.00 $1,077.00 $1,435.00 $1,793.00 $2,151.00
5 $363.00 $721.00 $1,079.00 $1,437.00 $1,795.00 $2,153.00
6 $364.00 $722.00 $1,080.00 $1,438.00 $1,796.00 $2,154.00
7 $365.00 $723.00 $1,081.00 $1,439.00 $1,797.00 $2,155.00
8 $366.00 $724.00 $1,082.00 $1,440.00 $1,798.00 $2,156.00
9 $367.00 $725.00 $1,083.00 $1,441.00 $1,799.00 $2,157.00
10 $368.00 $726.00 $1,084.00 $1,442.00 $1,800.00 $2,158.00
11 $369.00 $727.00 $1,085.00 $1,443.00 $1,801.00 $2,159.00
12 $370.00 $728.00 $1,086.00 $1,444.00 $1,802.00 $2,160.00
14 $372.00 $730.00 $1,088.00 $1,446.00 $1,804.00 $2,162.00
15 $373.00 $731.00 $1,089.00 $1,447.00 $1,805.00 $2,163.00
16 $374.00 $732.00 $1,090.00 $1,448.00 $1,806.00 $2,164.00
17 $375.00 $733.00 $1,091.00 $1,449.00 $1,807.00 $2,165.00
18 $376.00 $734.00 $1,092.00 $1,450.00 $1,808.00 $2,166.00
19 $377.00 $735.00 $1,093.00 $1,451.00 $1,809.00 $2,167.00
20 $378.00 $736.00 $1,094.00 $1,452.00 $1,810.00 $2,168.00
21 $379.00 $737.00 $1,095.00 $1,453.00 $1,811.00 $2,169.00
22 $380.00 $738.00 $1,096.00 $1,454.00 $1,812.00 $2,170.00
23 $381.00 $739.00 $1,097.00 $1,455.00 $1,813.00 $2,171.00
24 $382.00 $740.00 $1,098.00 $1,456.00 $1,814.00 $2,172.00
25 $383.00 $741.00 $1,099.00 $1,457.00 $1,815.00 $2,173.00
26 $384.00 $742.00 $1,100.00 $1,458.00 $1,816.00 $2,174.00
27 $385.00 $743.00 $1,101.00 $1,459.00 $1,817.00 $2,175.00
28 $386.00 $744.00 $1,102.00 $1,460.00 $1,818.00 $2,176.00
29 $387.00 $745.00 $1,103.00 $1,461.00 $1,819.00 $2,177.00
30 $388.00 $746.00 $1,104.00 $1,462.00 $1,820.00 $2,178.00
31 $389.00 $747.00 $1,105.00 $1,463.00 $1,821.00 $2,179.00
32 $390.00 $748.00 $1,106.00 $1,464.00 $1,822.00 $2,180.00
33 $391.00 $749.00 $1,107.00 $1,465.00 $1,823.00 $2,181.00
34 $392.00 $750.00 $1,108.00 $1,466.00 $1,824.00 $2,182.00
37 $395.00 $753.00 $1,111.00 $1,469.00 $1,827.00 $2,185.00
38 $396.00 $754.00 $1,112.00 $1,470.00 $1,828.00 $2,186.00
43 $401.00 $759.00 $1,117.00 $1,475.00 $1,833.00 $2,191.00
44 $402.00 $760.00 $1,118.00 $1,476.00 $1,834.00 $2,192.00
48 $406.00 $764.00 $1,122.00 $1,480.00 $1,838.00 $2,196.00
82 $440.00 $798.00 $1,156.00 $1,514.00 $1,872.00 $2,230.00
83 $441.00 $799.00 $1,157.00 $1,515.00 $1,873.00 $2,231.00
86 $444.00 $802.00 $1,160.00 $1,518.00 $1,876.00 $2,234.00
96 $454.00 $812.00 $1,170.00 $1,528.00 $1,886.00 $2,244.00
99 $457.00 $815.00 $1,173.00 $1,531.00 $1,889.00 $2,247.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Monday
STORE 1 2 3 4 5 6
3 $163.00 $323.00 $483.00 $643.00 $803.00 $963.00
5 $165.00 $325.00 $485.00 $645.00 $805.00 $965.00
6 $166.00 $326.00 $486.00 $646.00 $806.00 $966.00
7 $167.00 $327.00 $487.00 $647.00 $807.00 $967.00
8 $168.00 $328.00 $488.00 $648.00 $808.00 $968.00
9 $169.00 $329.00 $489.00 $649.00 $809.00 $969.00
10 $170.00 $330.00 $490.00 $650.00 $810.00 $970.00
11 $171.00 $331.00 $491.00 $651.00 $811.00 $971.00
12 $172.00 $332.00 $492.00 $652.00 $812.00 $972.00
14 $174.00 $334.00 $494.00 $654.00 $814.00 $974.00
15 $175.00 $335.00 $495.00 $655.00 $815.00 $975.00
16 $176.00 $336.00 $496.00 $656.00 $816.00 $976.00
17 $177.00 $337.00 $497.00 $657.00 $817.00 $977.00
18 $178.00 $338.00 $498.00 $658.00 $818.00 $978.00
19 $179.00 $339.00 $499.00 $659.00 $819.00 $979.00
20 $180.00 $340.00 $500.00 $660.00 $820.00 $980.00
21 $181.00 $341.00 $501.00 $661.00 $821.00 $981.00
22 $182.00 $342.00 $502.00 $662.00 $822.00 $982.00
23 $183.00 $343.00 $503.00 $663.00 $823.00 $983.00
24 $184.00 $344.00 $504.00 $664.00 $824.00 $984.00
25 $185.00 $345.00 $505.00 $665.00 $825.00 $985.00
26 $186.00 $346.00 $506.00 $666.00 $826.00 $986.00
27 $187.00 $347.00 $507.00 $667.00 $827.00 $987.00
28 $188.00 $348.00 $508.00 $668.00 $828.00 $988.00
29 $189.00 $349.00 $509.00 $669.00 $829.00 $989.00
30 $190.00 $350.00 $510.00 $670.00 $830.00 $990.00
31 $191.00 $351.00 $511.00 $671.00 $831.00 $991.00
32 $192.00 $352.00 $512.00 $672.00 $832.00 $992.00
33 $193.00 $353.00 $513.00 $673.00 $833.00 $993.00
34 $194.00 $354.00 $514.00 $674.00 $834.00 $994.00
37 $197.00 $357.00 $517.00 $677.00 $837.00 $997.00
38 $198.00 $358.00 $518.00 $678.00 $838.00 $998.00
43 $203.00 $363.00 $523.00 $683.00 $843.00 $1,003.00
44 $204.00 $364.00 $524.00 $684.00 $844.00 $1,004.00
48 $208.00 $368.00 $528.00 $688.00 $848.00 $1,008.00
82 $242.00 $402.00 $562.00 $722.00 $882.00 $1,042.00
83 $243.00 $403.00 $563.00 $723.00 $883.00 $1,043.00
86 $246.00 $406.00 $566.00 $726.00 $886.00 $1,046.00
96 $256.00 $416.00 $576.00 $736.00 $896.00 $1,056.00
99 $259.00 $419.00 $579.00 $739.00 $899.00 $1,059.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Tuesday
STORE Dept 1 Dept 2 Dept 3 Dept 4 Dept 5 Dept 6
3 $127.00 $251.00 $375.00 $499.00 $623.00 $747.00
5 $129.00 $253.00 $377.00 $501.00 $625.00 $749.00
6 $130.00 $254.00 $378.00 $502.00 $626.00 $750.00
7 $131.00 $255.00 $379.00 $503.00 $627.00 $751.00
8 $132.00 $256.00 $380.00 $504.00 $628.00 $752.00
9 $133.00 $257.00 $381.00 $505.00 $629.00 $753.00
10 $134.00 $258.00 $382.00 $506.00 $630.00 $754.00
11 $135.00 $259.00 $383.00 $507.00 $631.00 $755.00
12 $136.00 $260.00 $384.00 $508.00 $632.00 $756.00
14 $138.00 $262.00 $386.00 $510.00 $634.00 $758.00
15 $139.00 $263.00 $387.00 $511.00 $635.00 $759.00
16 $140.00 $264.00 $388.00 $512.00 $636.00 $760.00
17 $141.00 $265.00 $389.00 $513.00 $637.00 $761.00
18 $142.00 $266.00 $390.00 $514.00 $638.00 $762.00
19 $143.00 $267.00 $391.00 $515.00 $639.00 $763.00
20 $144.00 $268.00 $392.00 $516.00 $640.00 $764.00
21 $145.00 $269.00 $393.00 $517.00 $641.00 $765.00
22 $146.00 $270.00 $394.00 $518.00 $642.00 $766.00
23 $147.00 $271.00 $395.00 $519.00 $643.00 $767.00
24 $148.00 $272.00 $396.00 $520.00 $644.00 $768.00
25 $149.00 $273.00 $397.00 $521.00 $645.00 $769.00
26 $150.00 $274.00 $398.00 $522.00 $646.00 $770.00
27 $151.00 $275.00 $399.00 $523.00 $647.00 $771.00
28 $152.00 $276.00 $400.00 $524.00 $648.00 $772.00
29 $153.00 $277.00 $401.00 $525.00 $649.00 $773.00
30 $154.00 $278.00 $402.00 $526.00 $650.00 $774.00
31 $155.00 $279.00 $403.00 $527.00 $651.00 $775.00
32 $156.00 $280.00 $404.00 $528.00 $652.00 $776.00
33 $157.00 $281.00 $405.00 $529.00 $653.00 $777.00
34 $158.00 $282.00 $406.00 $530.00 $654.00 $778.00
37 $161.00 $285.00 $409.00 $533.00 $657.00 $781.00
38 $162.00 $286.00 $410.00 $534.00 $658.00 $782.00
43 $167.00 $291.00 $415.00 $539.00 $663.00 $787.00
44 $168.00 $292.00 $416.00 $540.00 $664.00 $788.00
48 $172.00 $296.00 $420.00 $544.00 $668.00 $792.00
82 $206.00 $330.00 $454.00 $578.00 $702.00 $826.00
83 $207.00 $331.00 $455.00 $579.00 $703.00 $827.00
86 $210.00 $334.00 $458.00 $582.00 $706.00 $830.00
96 $220.00 $344.00 $468.00 $592.00 $716.00 $840.00
99 $223.00 $347.00 $471.00 $595.00 $719.00 $843.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Wednesday
STORE 1 2 3 4 5 6
3 $793.00 $1,583.00 $2,373.00 $3,163.00 $3,953.00 $4,743.00
5 $795.00 $1,585.00 $2,375.00 $3,165.00 $3,955.00 $4,745.00
6 $796.00 $1,586.00 $2,376.00 $3,166.00 $3,956.00 $4,746.00
7 $797.00 $1,587.00 $2,377.00 $3,167.00 $3,957.00 $4,747.00
8 $798.00 $1,588.00 $2,378.00 $3,168.00 $3,958.00 $4,748.00
9 $799.00 $1,589.00 $2,379.00 $3,169.00 $3,959.00 $4,749.00
10 $800.00 $1,590.00 $2,380.00 $3,170.00 $3,960.00 $4,750.00
11 $801.00 $1,591.00 $2,381.00 $3,171.00 $3,961.00 $4,751.00
12 $802.00 $1,592.00 $2,382.00 $3,172.00 $3,962.00 $4,752.00
14 $804.00 $1,594.00 $2,384.00 $3,174.00 $3,964.00 $4,754.00
15 $805.00 $1,595.00 $2,385.00 $3,175.00 $3,965.00 $4,755.00
16 $806.00 $1,596.00 $2,386.00 $3,176.00 $3,966.00 $4,756.00
17 $807.00 $1,597.00 $2,387.00 $3,177.00 $3,967.00 $4,757.00
18 $808.00 $1,598.00 $2,388.00 $3,178.00 $3,968.00 $4,758.00
19 $809.00 $1,599.00 $2,389.00 $3,179.00 $3,969.00 $4,759.00
20 $810.00 $1,600.00 $2,390.00 $3,180.00 $3,970.00 $4,760.00
21 $811.00 $1,601.00 $2,391.00 $3,181.00 $3,971.00 $4,761.00
22 $812.00 $1,602.00 $2,392.00 $3,182.00 $3,972.00 $4,762.00
23 $813.00 $1,603.00 $2,393.00 $3,183.00 $3,973.00 $4,763.00
24 $814.00 $1,604.00 $2,394.00 $3,184.00 $3,974.00 $4,764.00
25 $815.00 $1,605.00 $2,395.00 $3,185.00 $3,975.00 $4,765.00
26 $816.00 $1,606.00 $2,396.00 $3,186.00 $3,976.00 $4,766.00
27 $817.00 $1,607.00 $2,397.00 $3,187.00 $3,977.00 $4,767.00
28 $818.00 $1,608.00 $2,398.00 $3,188.00 $3,978.00 $4,768.00
29 $819.00 $1,609.00 $2,399.00 $3,189.00 $3,979.00 $4,769.00
30 $820.00 $1,610.00 $2,400.00 $3,190.00 $3,980.00 $4,770.00
31 $821.00 $1,611.00 $2,401.00 $3,191.00 $3,981.00 $4,771.00
32 $822.00 $1,612.00 $2,402.00 $3,192.00 $3,982.00 $4,772.00
33 $823.00 $1,613.00 $2,403.00 $3,193.00 $3,983.00 $4,773.00
34 $824.00 $1,614.00 $2,404.00 $3,194.00 $3,984.00 $4,774.00
37 $827.00 $1,617.00 $2,407.00 $3,197.00 $3,987.00 $4,777.00
38 $828.00 $1,618.00 $2,408.00 $3,198.00 $3,988.00 $4,778.00
43 $833.00 $1,623.00 $2,413.00 $3,203.00 $3,993.00 $4,783.00
44 $834.00 $1,624.00 $2,414.00 $3,204.00 $3,994.00 $4,784.00
48 $838.00 $1,628.00 $2,418.00 $3,208.00 $3,998.00 $4,788.00
82 $872.00 $1,662.00 $2,452.00 $3,242.00 $4,032.00 $4,822.00
83 $873.00 $1,663.00 $2,453.00 $3,243.00 $4,033.00 $4,823.00
86 $876.00 $1,666.00 $2,456.00 $3,246.00 $4,036.00 $4,826.00
96 $886.00 $1,676.00 $2,466.00 $3,256.00 $4,046.00 $4,836.00
99 $889.00 $1,679.00 $2,469.00 $3,259.00 $4,049.00 $4,839.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Thursday
STORE 1 2 3 4 5 6
3 $460.00 $917.00 $1,374.00 $1,831.00 $2,288.00 $2,745.00
5 $462.00 $919.00 $1,376.00 $1,833.00 $2,290.00 $2,747.00
6 $463.00 $920.00 $1,377.00 $1,834.00 $2,291.00 $2,748.00
7 $464.00 $921.00 $1,378.00 $1,835.00 $2,292.00 $2,749.00
8 $465.00 $922.00 $1,379.00 $1,836.00 $2,293.00 $2,750.00
9 $466.00 $923.00 $1,380.00 $1,837.00 $2,294.00 $2,751.00
10 $467.00 $924.00 $1,381.00 $1,838.00 $2,295.00 $2,752.00
11 $468.00 $925.00 $1,382.00 $1,839.00 $2,296.00 $2,753.00
12 $469.00 $926.00 $1,383.00 $1,840.00 $2,297.00 $2,754.00
14 $471.00 $928.00 $1,385.00 $1,842.00 $2,299.00 $2,756.00
15 $472.00 $929.00 $1,386.00 $1,843.00 $2,300.00 $2,757.00
16 $473.00 $930.00 $1,387.00 $1,844.00 $2,301.00 $2,758.00
17 $474.00 $931.00 $1,388.00 $1,845.00 $2,302.00 $2,759.00
18 $475.00 $932.00 $1,389.00 $1,846.00 $2,303.00 $2,760.00
19 $476.00 $933.00 $1,390.00 $1,847.00 $2,304.00 $2,761.00
20 $477.00 $934.00 $1,391.00 $1,848.00 $2,305.00 $2,762.00
21 $478.00 $935.00 $1,392.00 $1,849.00 $2,306.00 $2,763.00
22 $479.00 $936.00 $1,393.00 $1,850.00 $2,307.00 $2,764.00
23 $480.00 $937.00 $1,394.00 $1,851.00 $2,308.00 $2,765.00
24 $481.00 $938.00 $1,395.00 $1,852.00 $2,309.00 $2,766.00
25 $482.00 $939.00 $1,396.00 $1,853.00 $2,310.00 $2,767.00
26 $483.00 $940.00 $1,397.00 $1,854.00 $2,311.00 $2,768.00
27 $484.00 $941.00 $1,398.00 $1,855.00 $2,312.00 $2,769.00
28 $485.00 $942.00 $1,399.00 $1,856.00 $2,313.00 $2,770.00
29 $486.00 $943.00 $1,400.00 $1,857.00 $2,314.00 $2,771.00
30 $487.00 $944.00 $1,401.00 $1,858.00 $2,315.00 $2,772.00
31 $488.00 $945.00 $1,402.00 $1,859.00 $2,316.00 $2,773.00
32 $489.00 $946.00 $1,403.00 $1,860.00 $2,317.00 $2,774.00
33 $490.00 $947.00 $1,404.00 $1,861.00 $2,318.00 $2,775.00
34 $491.00 $948.00 $1,405.00 $1,862.00 $2,319.00 $2,776.00
37 $494.00 $951.00 $1,408.00 $1,865.00 $2,322.00 $2,779.00
38 $495.00 $952.00 $1,409.00 $1,866.00 $2,323.00 $2,780.00
43 $500.00 $957.00 $1,414.00 $1,871.00 $2,328.00 $2,785.00
44 $501.00 $958.00 $1,415.00 $1,872.00 $2,329.00 $2,786.00
48 $505.00 $962.00 $1,419.00 $1,876.00 $2,333.00 $2,790.00
82 $539.00 $996.00 $1,453.00 $1,910.00 $2,367.00 $2,824.00
83 $540.00 $997.00 $1,454.00 $1,911.00 $2,368.00 $2,825.00
86 $543.00 $1,000.00 $1,457.00 $1,914.00 $2,371.00 $2,828.00
96 $553.00 $1,010.00 $1,467.00 $1,924.00 $2,381.00 $2,838.00
99 $556.00 $1,013.00 $1,470.00 $1,927.00 $2,384.00 $2,841.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Friday
STORE 1 2 3 4 5 6
3 $745.00 $1,487.00 $2,229.00 $2,971.00 $3,713.00 $4,071.00
5 $747.00 $1,489.00 $2,231.00 $2,973.00 $3,715.00 $4,073.00
6 $748.00 $1,490.00 $2,232.00 $2,974.00 $3,716.00 $4,074.00
7 $749.00 $1,491.00 $2,233.00 $2,975.00 $3,717.00 $4,075.00
8 $750.00 $1,492.00 $2,234.00 $2,976.00 $3,718.00 $4,076.00
9 $751.00 $1,493.00 $2,235.00 $2,977.00 $3,719.00 $4,077.00
10 $752.00 $1,494.00 $2,236.00 $2,978.00 $3,720.00 $4,078.00
11 $753.00 $1,495.00 $2,237.00 $2,979.00 $3,721.00 $4,079.00
12 $754.00 $1,496.00 $2,238.00 $2,980.00 $3,722.00 $4,080.00
14 $756.00 $1,498.00 $2,240.00 $2,982.00 $3,724.00 $4,082.00
15 $757.00 $1,499.00 $2,241.00 $2,983.00 $3,725.00 $4,083.00
16 $758.00 $1,500.00 $2,242.00 $2,984.00 $3,726.00 $4,084.00
17 $759.00 $1,501.00 $2,243.00 $2,985.00 $3,727.00 $4,085.00
18 $760.00 $1,502.00 $2,244.00 $2,986.00 $3,728.00 $4,086.00
19 $761.00 $1,503.00 $2,245.00 $2,987.00 $3,729.00 $4,087.00
20 $762.00 $1,504.00 $2,246.00 $2,988.00 $3,730.00 $4,088.00
21 $763.00 $1,505.00 $2,247.00 $2,989.00 $3,731.00 $4,089.00
22 $764.00 $1,506.00 $2,248.00 $2,990.00 $3,732.00 $4,090.00
23 $765.00 $1,507.00 $2,249.00 $2,991.00 $3,733.00 $4,091.00
24 $766.00 $1,508.00 $2,250.00 $2,992.00 $3,734.00 $4,092.00
25 $767.00 $1,509.00 $2,251.00 $2,993.00 $3,735.00 $4,093.00
26 $768.00 $1,510.00 $2,252.00 $2,994.00 $3,736.00 $4,094.00
27 $769.00 $1,511.00 $2,253.00 $2,995.00 $3,737.00 $4,095.00
28 $770.00 $1,512.00 $2,254.00 $2,996.00 $3,738.00 $4,096.00
29 $771.00 $1,513.00 $2,255.00 $2,997.00 $3,739.00 $4,097.00
30 $772.00 $1,514.00 $2,256.00 $2,998.00 $3,740.00 $4,098.00
31 $773.00 $1,515.00 $2,257.00 $2,999.00 $3,741.00 $4,099.00
32 $774.00 $1,516.00 $2,258.00 $3,000.00 $3,742.00 $4,100.00
33 $775.00 $1,517.00 $2,259.00 $3,001.00 $3,743.00 $4,101.00
34 $776.00 $1,518.00 $2,260.00 $3,002.00 $3,744.00 $4,102.00
37 $779.00 $1,521.00 $2,263.00 $3,005.00 $3,747.00 $4,105.00
38 $780.00 $1,522.00 $2,264.00 $3,006.00 $3,748.00 $4,106.00
43 $785.00 $1,527.00 $2,269.00 $3,011.00 $3,753.00 $4,111.00
44 $786.00 $1,528.00 $2,270.00 $3,012.00 $3,754.00 $4,112.00
48 $790.00 $1,532.00 $2,274.00 $3,016.00 $3,758.00 $4,116.00
82 $824.00 $1,566.00 $2,308.00 $3,050.00 $3,792.00 $4,150.00
83 $825.00 $1,567.00 $2,309.00 $3,051.00 $3,793.00 $4,151.00
86 $828.00 $1,570.00 $2,312.00 $3,054.00 $3,796.00 $4,154.00
96 $838.00 $1,580.00 $2,322.00 $3,064.00 $3,806.00 $4,164.00
99 $841.00 $1,583.00 $2,325.00 $3,067.00 $3,809.00 $4,167.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Saturday
STORE 1 2 3 4 5 6
3 $856.00 $1,709.00 $2,562.00 $3,415.00 $4,268.00 $5,121.00
5 $858.00 $1,711.00 $2,564.00 $3,417.00 $4,270.00 $5,123.00
6 $859.00 $1,712.00 $2,565.00 $3,418.00 $4,271.00 $5,124.00
7 $860.00 $1,713.00 $2,566.00 $3,419.00 $4,272.00 $5,125.00
8 $861.00 $1,714.00 $2,567.00 $3,420.00 $4,273.00 $5,126.00
9 $862.00 $1,715.00 $2,568.00 $3,421.00 $4,274.00 $5,127.00
10 $863.00 $1,716.00 $2,569.00 $3,422.00 $4,275.00 $5,128.00
11 $864.00 $1,717.00 $2,570.00 $3,423.00 $4,276.00 $5,129.00
12 $865.00 $1,718.00 $2,571.00 $3,424.00 $4,277.00 $5,130.00
14 $867.00 $1,720.00 $2,573.00 $3,426.00 $4,279.00 $5,132.00
15 $868.00 $1,721.00 $2,574.00 $3,427.00 $4,280.00 $5,133.00
16 $869.00 $1,722.00 $2,575.00 $3,428.00 $4,281.00 $5,134.00
17 $870.00 $1,723.00 $2,576.00 $3,429.00 $4,282.00 $5,135.00
18 $871.00 $1,724.00 $2,577.00 $3,430.00 $4,283.00 $5,136.00
19 $872.00 $1,725.00 $2,578.00 $3,431.00 $4,284.00 $5,137.00
20 $873.00 $1,726.00 $2,579.00 $3,432.00 $4,285.00 $5,138.00
21 $874.00 $1,727.00 $2,580.00 $3,433.00 $4,286.00 $5,139.00
22 $875.00 $1,728.00 $2,581.00 $3,434.00 $4,287.00 $5,140.00
23 $876.00 $1,729.00 $2,582.00 $3,435.00 $4,288.00 $5,141.00
24 $877.00 $1,730.00 $2,583.00 $3,436.00 $4,289.00 $5,142.00
25 $878.00 $1,731.00 $2,584.00 $3,437.00 $4,290.00 $5,143.00
26 $879.00 $1,732.00 $2,585.00 $3,438.00 $4,291.00 $5,144.00
27 $880.00 $1,733.00 $2,586.00 $3,439.00 $4,292.00 $5,145.00
28 $881.00 $1,734.00 $2,587.00 $3,440.00 $4,293.00 $5,146.00
29 $882.00 $1,735.00 $2,588.00 $3,441.00 $4,294.00 $5,147.00
30 $883.00 $1,736.00 $2,589.00 $3,442.00 $4,295.00 $5,148.00
31 $884.00 $1,737.00 $2,590.00 $3,443.00 $4,296.00 $5,149.00
32 $885.00 $1,738.00 $2,591.00 $3,444.00 $4,297.00 $5,150.00
33 $886.00 $1,739.00 $2,592.00 $3,445.00 $4,298.00 $5,151.00
34 $887.00 $1,740.00 $2,593.00 $3,446.00 $4,299.00 $5,152.00
37 $890.00 $1,743.00 $2,596.00 $3,449.00 $4,302.00 $5,155.00
38 $891.00 $1,744.00 $2,597.00 $3,450.00 $4,303.00 $5,156.00
43 $896.00 $1,749.00 $2,602.00 $3,455.00 $4,308.00 $5,161.00
44 $897.00 $1,750.00 $2,603.00 $3,456.00 $4,309.00 $5,162.00
48 $901.00 $1,754.00 $2,607.00 $3,460.00 $4,313.00 $5,166.00
82 $935.00 $1,788.00 $2,641.00 $3,494.00 $4,347.00 $5,200.00
83 $936.00 $1,789.00 $2,642.00 $3,495.00 $4,348.00 $5,201.00
86 $939.00 $1,792.00 $2,645.00 $3,498.00 $4,351.00 $5,204.00
96 $949.00 $1,802.00 $2,655.00 $3,508.00 $4,361.00 $5,214.00
99 $952.00 $1,805.00 $2,658.00 $3,511.00 $4,364.00 $5,217.00
District 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 2 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 3 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
District 99 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00


Below is just one of the Store tabs (43) as a test report. All the cells next to the dept # need to be filled for each day
File name is Sales Reports, Tab name is Store 43
Sunday, 11/25/18 <- NOTE This date is one cell
Store 43 Actual Net Sales Projected Net Sales <- NOTE Store 43 is one cell
Store Total
Dept #s Actual Net Sales
Dept. 1 <- NOTE This date is one cell
Dept. 2 Formula needed here
Dept. 3 Formula needed here
Dept. 4 Formula needed here
Dept. 5 $1,833.00 <- This should be the result, next look below for Monday
Dept. 6 Formula needed here
Dept. 7 nothing needed here
$0.00 .00000
Monday, 11/26/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales
Dept. 1 Formula needed here
Dept. 2 Formula needed here
Dept. 3 Formula needed here
Dept. 4 $683.00 <- this should be the result
Dept. 5 Formula needed here
Dept. 6 Formula needed here
Dept. 7 nothing needed here
$0.00 .00000
Tuesday, 11/27/18
Store #43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1 etc.
Dept. 2 etc
Dept. 3 "
Dept. 4 ".
Dept. 5 ."
Dept. 6 ."
Dept. 7 ."
$0.00 .00000
Wednesday, 11/28/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Thursday, 11/29/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Friday, 11/30/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
$0.00 .00000
Saturday, 12/01/18
Store 43 Actual Net Sales Projected Net Sales
Store Total
Dept #s Actual Net Sales Projected Net Sales
Dept. 1
Dept. 2
Dept. 3
Dept. 4
Dept. 5
Dept. 6
Dept. 7
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Anyone have some thoughts on my problem?
This can't be too hard to make a formula for this?
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,309
Members
448,564
Latest member
ED38

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