Can I reference tabs using input cells?
Hello,
I am trying to create a fancy budget sheet and am uploading spreadsheet data from my bank to calculate with. My goal is to calculate items on a month-to-month basis. All of my data tabs are labeled as such: April - Checking, March - Checking, etc. I might just combine all the data into one tab for simplicity and INDEX MATCH by date, but I was wondering if it would be possible to have one input cell for my month of choice (April, March), and then have a formula referring to that input cell that changes which tab it pulls data from.
Here's the monstrosity I tried lol which obviously didn't work but I'm not sure how I would fix it. I wanted the input cell to feed the month into the formula to pull from a specific tab. Base Inputs!B4 is the month (March), and March 26 EXP - Credit Card is the tab I'm trying to pull from, but I have another tab for April that I was hoping to switch between for the data source by changing the "input cell month". Column H returns Balances, Column A returns dates, and A32 is the match for dates.
=INDEX('"*"&'Base Inputs'!$B$4&"*" 26 EXP - Credit Card'!$H:$H, MATCH(A32, '"*"&'Base Inputs'!$B$4&"*" 26 EXP - Credit Card'!$A:$A, 0))
Is what I'm asking even possible? Let me know!
[link] [comments]
Want to read more?
Check out the full article on the original site