Need Advise_If condition!! :-(

[Paul Cherian]

Hi there..

I am new to excel ...

I want an automated formula to catch the cell values of sheet 1 to sheet 2 under the pre-defined group.

Status may be changing time to time and it should reflect under sheet 2 and according to the status change project name should be changing on the sheet 2.

I tried to do it with If condition but failed to finalize it!! :-(

Please help me !!

I have attached how my report looks like!

[Richard Buttrey]

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary as. It is always easier to advise if we can see your request in its context. Pictures are rarely much use for the reasons mentioned in the rules area and no one is going to recreate your workbook when you have one available.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[Paul Cherian]

Oh yes.. Please find attached excel book for your review!

Thanks in Advance :-)

[Richard Buttrey]

Hi,

In B3 and copied to all relevant cells

Please Login or Register  to view this content.

[Paul Cherian]

Thanks! But my results should be the green highlighted text. Sorry I forgot to mention on the workbook. Could you please look in to that.

[Richard Buttrey]

Hi,

In that case I don't understand your data.

Manually, clearly add the results you expect to see , tell us which are the results cells and how you arrived at them.