lookup to find earliest finish for predecessors in scheduling program

Innoguide

Board Regular
Joined
Sep 13, 2011
Messages
159
I am trying to build a critical path scheduling program and have 1 task per row starting in row 12 with 4 separate columns (H, I, J,K) where predecessor tasks are entered using the ID number of the predecessor (1-200) which are in A12:A211. There's nothing set in stone about 4 columns - it is usually more than enough for most schedules). I need to use this info to calculate the earliest start of each task based on the latest earliest finish of all of its predecessors. The earliest finish for each task us located in f12:f211

To do this, I have 4 columns AA through AD where I need to store the value of the cells in f12:f211 that correspond to the predecessor ID's - could anyone suggest which formula could be used to do this.

Thanks in advance!
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
So for each column AA-AD you need do extract coresponding data from Column F where ID in column A matches the one in H-K?
 
Upvote 0
Exactly Robert - I need to extract the values from column f for each of the rows matching the labels in h-K, and place the in columns aa-ad

Thanks
 
Upvote 0
Try this:
Array formula confirm CR+SHIFT+ENTER
=MIN(IF($A$12:$A$211=H$12,$F$12:$F$211))

if it does not work, cold you post a sample of your data,please?
 
Upvote 0

Forum statistics

Threads
1,223,171
Messages
6,170,480
Members
452,332
Latest member
The2ndQuest

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top