Updating Array Formula

Hi Guys,

I have opened another thread for this as I have tagged the previous one as solved.

In the previous thread, a formula was given (Thanks to DILIPandey). It works fine, however, I was unable to tweak it as I needed to add some sheets to the formula.

Here's the old thread: http://www.excelforum.com/excel-form...le-sheets.html

Here's the formula I need to update:

Please Login or Register  to view this content.

I would like to add S2 S3 and S4 versions of that code so that it will also look into those sheets.

Another thing, would it be possible to add a formula that will load a value for Ph1 - Ph11 from the index sheet to S1-S4 sheets? Also, I would like the formula to determine the date the value in C column has been added and return a value under that date and stop any consecutive fetching after a value has been added to a row. Please see sample.

Also, would anyone point me to a guide on excel formulas, especially look ups with specific conditions.

Thanks in advance, happy new year guys!

Consider a database format - for flexibility.
See sample - not solution.
//Ola


Or try something like ='S1:S4'!$D$3:$D$10, with the risk of messy formulas.