Fill in missing values of one row with the rows beneath it if the rows beneath match

Hi,

Does anyone know of a formula that will fill in the missing values of one row with the row(s) beneath it, if the rows beneath it contain values and if they meet a certain criteria (and then paste this formula down an entire column)?

Below is an example of the before and after scenarios which should make my question easier to understand.

Attachment 201334

If anyone can help it will be greatly appreciated.

Thank you

The formula below, copied down entire column C on Sheet2, assumes that you are referencing the Master, Sheet1 (=Sheet1!C2, for example). But where there is a blank cell in the Master, it will reference the cell below itself, which also references either the Master or the cell below IT, and so on.

=IF(Sheet1!C2="",C3,Sheet1!C2)
=IF(Sheet1!C3="",C4,Sheet1!C3)
=IF(Sheet1!C4="",C5,Sheet1!C4)
...and so on.

Is that what you're trying to do?