Index Matching not working and need to pull data from large database

Hi all,

I have a large piece of data with that is organized by cost type (construction, operating revenues, etc, revenues from asset sales) and by year for each asset

I need to re-organize my data by asset and have the respective cost types under each section. (e.g. rows 14-22)

Can someone please give me a formula to enter into row C15 that I can just drag across and down into all of the pink colored cells. I put the values of what it should be as a point of reference. I also cut the data set much shorter than what I actually have. Ideally, it is the same formula I can just drag across and down, rather than having several index matches. (Maybe an index match match might work?)

Thanks

Duplicate post ?????

No, I asked something else earlier. Please let me know if anything in my request was unclear. I have 20+ asset classes and with about 15 cost types so it would be nice to have 1 formula but I'm stuck on it

It will be used to feed into other formulas / valuations.

Also provides us with a different way of looking at the dataset

In C15

=OFFSET($C$1,MATCH($A15,$A$2:$A$12,0)+MATCH($A$14,$A$2:$A$12,0)-1,COLUMNS($C:C)-1)

Copy across and down to row 17

Copy to C20 and change highlighted references

See attached row 24 onward

Hi John,

Thanks for the formula. It works well on the initial sheer but whe I try and adapt the formula to my large sheet it's not working for me.

I think I am messing up the formula. I attached for the full data sheet but grouped the data you don't need to see.

I am trying to enter the formula in cell G233 but as you can see it is not working. Row 233 should match what is in row 234.

Can you please provide some guidance?

Thanks

Try

=IFERROR(OFFSET($C$128,MATCH($C233,$C$129:$C$185,0)+MATCH($C$232,$C$129:$C$185,0)-1,COLUMNS($C:G)-1),0)

This worked

Thanks