jessabell75

New Member
Joined
May 11, 2018
Messages
1
I have a huge spreadsheet that updates monthly and I want to insert a column at the beginning for ease in reconciliation of the current balance and current AD. See example below...I basically want to update the date field on a monthly basis and get the current balances populated. Thinking this requires a sumproduct but I'm having trouble remembering how to set this up. Any help is appreciated!


Sheet1

CDEFGHIJKLM
3Current MonthCurrentCurrent DeprADBalance DeprADBalance
42/1/2018ADBalance 1/1/20181/1/20181/1/2018 2/1/20182/1/20182/1/2018
5 5006000 150025003000 48005006000

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 99px;"><col style="width: 99px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 12px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
try


Excel 2010
CDEFGHIJKLM
1Current MonthCurrentCurrentDeprADBalanceDeprADBalance
22/1/2018ADBalance1/1/20181/1/20181/1/20182/1/20182/1/20182/1/2018
35006,0001,5002,5003,0004,8005006,000
Sheet1
Cell Formulas
RangeFormula
D3{=INDEX($G$3:$M$3,MATCH($C2&D2,$G$2:$M$2&$G$1:$M$1,0))}
E3{=INDEX($G$3:$M$3,MATCH($C2&E2,$G$2:$M$2&$G$1:$M$1,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,037
Members
448,543
Latest member
MartinLarkin

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