A 3D Schedule ?

[MGumbrell]

In a typical schedule (as attached) with information completed against a row and a column.

Say that this schedule was completed by five different companies (currently only one can be shown in this method) Is there a way of creating a cubed schedule that theoretically each one of the schedules from each comany can sit on top to build a 10x5x5 high cubed schedule that can be interogated with VLOOKUP or HLOOKUP or something else. Or is this the start of a pivot table?

Regards, Matt

 

[HaHoBe]

Hi, Matt,

I´ll go complain as with my new glasses I can´t find the attachment. You could make very good use of the function Indirect as far as I understand the question.

Ciao,
Holger

 

[MGumbrell]

Thank You Holger

The more I review this the more I think that it is going to have to be a pivot table. I haven't created a pivot table yet so the next few weeks look interesting.

Matt