Excel 2010 - Nesting multiple IFs or other

[Charlie Bravo]

Using Excel 2010
I have a created a project plan in Excel where I am trying to make the start date of one task begin when another task ends. For example, my start date column is F and my end date column is H. My predecessor column is B. So if I need the task on line 30 to begin after the task on line 10, how's the best way to do this? I used neasted or multiple IFs so if I enter 10 in B30 my start cell (F30) becomes the value of H10. But as you can imagine this statement is very long.
Please help...thank you.

 

[sijpie]

Use the INDIRECT formula to point to the cell you want the value from. Since Bx holds the row number of the predecessor and the column with the end date is H, =INDIRECT("H"&Bx) will give you the required end date


Excel 2010

	B	C	D	E	F	G	H
Pred.Row

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]07-May[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]07-May[/TD]
[TD="align: right"][/TD]
[TD="align: right"]15-Aug[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]15-Aug[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet10​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F12[/TH]
[TD="align: left"]=INDIRECT("H"&B12)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]F13[/TH]
[TD="align: left"]=INDIRECT("H"&B13)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]