I am doing a project for work, and I am dealing with a large file with multiple tabs. I am building a table for a graph that is going to feed off of two data validation lists (B4 and T4). The graph/table is going to pull different information based off B4, which is either YTD or FY, and T4 which is multiple Regions. So I am using Indirect to reference my 2 tabs: SIMPLE_YTD, or SIMPLE_FY. However, I keep getting a #REF! error in my indirect formulas.
Here is the formula I am using: =INDEX(INDIRECT("SIMPLE_"&$B$4),MATCH(VLOOKUP($S$4,$AE$3:$AF$23,2,FALSE),INDIRECT("SIMPLE_"&$B$4),0),MATCH(R16,INDIRECT("SIMPLE_"&$B$4),0))
Am I using the indirect formula Wrong?
Any help would be greatly appreciated, thanks.
Bookmarks