2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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!

submitted by /u/Complex-Database6750
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#AI formula generation techniques
#formula generator
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
Can I reference tabs using input cells?