•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Change Sheet reference based on cell value
Hopefully the title makes sense.
Below is a snippet of what I'm working on. What I'm wanting to do is have the data table being referenced in the VLOOKUP change depending on the cell value above it. Right no I've just been manually changing each one to match. This is fine busy work but I get antsy after Data20.
I'm also open to other ideas if you have them. Thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#cloud-based spreadsheet applications
#VLOOKUP
#data table
#cell value
#Excel
#change reference