Related Posts
Hi, I have an offer for the position of Senior Associate at pwc AC Bangalore. Can you please tell if there is a permanent wfh and will they give it in writing. And how is the WLB at PWC AC Bangalore. Is it true that I will have to frequently work late at night. Is the shift timings 9 to 6 as the hr told me or it usually extends? Pwc AC PwC
2 in 1 laptop needed for MBA? Helpful at all?
Has anyone been terminated from Novartis?
Additional Posts in Excel Genius
Would anyone be willing to teach me vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.








It sounds like VLOOKUPs or INDEX MATCH MATCH (best practice) might serve you well here. You can put a specific date into cell A1 of the master sheet for example. Then VLOOKUP(A1, Range on ST Sheet, # of rows on ST sheet, 0) to pull data for that month from the ST sheet. You can do something similar for the others.
...cont. and outstanding loan balances.
To build on this, you can also reference the exact tab names in a row or column. SUMPRODUCT, INDIRECT, and SUMIF can pull the corresponding data by month as stated above from each table at its respective tab.
See below -
=SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!"&"rng"),criteria,INDIRECT("'"&sheets&"'!"&"sumrng")))
We’ve used this same formula before for the exact same reason this past year for a client with around 100 separate amortization tables. Also, if the data ranges are transposed, you may want to use OFFSET in there as well.