Hello,
I'm looking for some help with a large set of data that I can pull certain numbers from to create an interactive graph. I'm familiar with the IndexMatchMatch function but the issue that I have is that the data has the same cell name in each particular "store", so I can't wrap my head around how I can specify a store and the right data.
For example, Lets say I want to pull Rental Income from Store 2, not store 1,3,4, etc. for Feb 2014. I've attached a small sample of the data with random numbers. Hope you guys could help me out with this project. The alternative is to make an indexmatchmatch for each store, but I'm hoping there's another solution.
Thanks in advance.
Bookmarks