This is something i've always had in mind but never had much of a reason to put a lot of time into it until today, and now i'm stuck. What i'm looking to do is write a formula to reference other worksheets (basically to work with anything, sumifs, vlookup, if formulas, etc etc) that changes according to whats selected from a data validation drop down box. I've attached a spreadsheet that elaborates a little further. Is this a possibility without having to dive into VBA?
There's 53 worksheets for the spreadsheet i'm working with and the only thing i can think of is having a very lengthy =if formula that relates to every tab. But if there's an easier way, i'd love to know!
*Edit- SOLVED. =INDIRECT formula did the trick.
Bookmarks