•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