Formula to Combine two table information

[wiliam_s]

Hi
Table 1 includes the time needed to run each phase in month and the second table, including the required cost per month in each phase of the project, he plans to make a table in which the number of months projected for each phase of the project in Table 1, the cost Identify each phase in Table 2 in the respective month.
In the attached file you can see the expected result.
Thank you .
U1.png

[AliGW]

Who is 'he'?

How do you know which months belong to which phase (apart from the colour coding)?

[Glenn Kennedy]

Once I untangled the spider's web... it was clear. In D1, copied across and down:

=IFERROR(INDEX($I4:$K4,MATCH(0,INDEX(--(COUNTIF($C10:C10,$I4:$K4)=$D4:$F4),0),0)),"")

[Glenn Kennedy]

That should read D10 in my previous post...

[wiliam_s]

AliGW
I meant for myself
Pay attention to the structure of the tables Shown.
Very amazing response Glenn Kennedy.
Thank you so much

[AliGW]

Pay attention to the structure of the tables Shown.

You may not realise it, but this is a very rude response. Please do not respond to members who are trying to help in this way. If clarification is sought, then give it.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Glenn Kennedy]

you're welcome and thanks for the Rep.

[José Augusto]

Hi

I suppose this work

Please Login or Register  to view this content.

[wiliam_s]

You may not realise it, but this is a very rude response. Please do not respond to members who are trying to help in this way. If clarification is sought, then give it.

.

I'm so sorry
I'll consider these in other cases.
I'll apologize again

[AliGW]

Thank you.

[wiliam_s]

Hi

I suppose this work

Please Login or Register  to view this content.

Thank you
This method was also great