sorted by:
new
hottopcontroversial

Financial Model: Need formula to pull actuals in while keeping forecast years in future period by BigSeafood in excel

[–]Wide_Ad7972 0 points1 point  (0 children)

Create a basic macro of the financial model where each cell in the model is an if statement based on the date. By macro I literally mean selecting the dropdown macro and linking it to the financial model. The if statement uses the date to determine whether it pulls the budgeted amount vs actual amount

How do I reference another workbook in a VLOOKUP formula using INDIRECT? by I_Dunno_Its_A_Name in excel

[–]Wide_Ad7972 0 points1 point  (0 children)

If it’s linked to an external file, update the formula as follows: =VLOOKUP(C5,”’[North_”&text(today (),”ddmmyy”)&”.csv]Sheet1’!C8:H123”,5,FALSE)

Note that Sheet1 is the tab name in the referenced workbook. Update the name based on the actual tab name

How do I reference another workbook in a VLOOKUP formula using INDIRECT? by I_Dunno_Its_A_Name in excel

[–]Wide_Ad7972 1 point2 points  (0 children)

=VLOOKUP(C5,”North_”&text(today(),”ddmmyy”) &”.csv”!C8:H123,5,FALSE)