Hey,

I actually have read suggestions / help on finding data from a third column by searching based on two other column's data. Unfortunately, this only goes so far for me and I've been wracking my brain in vain to solve this.

On one sheet (Projections), I have a chart with two columns that feature drop down boxes. You can select a general then a more specific description. I also have a sheet (RawPivot) that is the summary of a Data sheet. The biggest problem I'm seeing is that for the specifics under a general, in the pivot table, the general only appears once and hence, using match(1,()*(),0) wouldn't work for me.

By this, I mean, the pivot looks something like:

December | 01
| 02
| 03
| ...
January | 01
| 02
| 03
| ...

So, if I wanted to get the data from the third column for December and 03, the match wouldn't work.

I've been trying to do something where I loop two matches within an index such that the general description would form the lowest boundary of an array form but I get an error when I do that.

The formula I was trying to work with was:

=Index(RawPivot!$D$1:$D$500,Match(C4,RawPivot!$C$(Match(B4,RawPivot!$B$1:$B$500,0):$C$500))

where C4 is the specialized and B4 is the general. The problem is that while the innermost Match comes out to a number, it can't actually be then used within calling an array... Any suggestions on how to solve this?

Thanks for any help!