Excel 2007 : iferror(index Formula returning blank cells

[Martin Chamberlin]

Can anyone help here. The formula works in another work sheet but has stopped in this one. Data entry is task "B1" to "B12" in row 12. You can change the duration of the task in C9 and D9.

Example
Delete "B1" in C12, then re enter it and see what happens. Try again in D12, it doesnt work?????

The table should return a replica of the output in row 22 using formula:
[=IFERROR(INDEX(C13:C20, MATCH(TRUE, C13:C20<>"", 0)), "")]

It works fine at data input cell C12 but stops when entering data into other row 12 cells.

Any advice appreciated please.

Chambo

[zbor]

What do you want as result in C21, D21 etc?

[khamilton]

Try this just a little tweak. ---> =IFERROR(INDEX(C13:C20, MATCH(TRUE, len(C13:C20)<>"", 0)), "")

[Martin Chamberlin]

The result is already there in row 21 for the data entered in C12

Just delete C12 and enter "B1" into say G12. Row 21 should populate the information automatically from G21 but it stays blank.

Thanks for the help so far.

[Martin Chamberlin]

That works the same as my formula but only in cell C12.

Thanks for trying

[zbor]

WHen you enter in G12 let say B1.
What should be written in G21 and what in C21?

[Martin Chamberlin]

WHen you enter in G12 let say B1.
What should be written in G21 and what in C21?

Have a look at the amended attachment. I have manually entered the result in row 21.

The results in row 21 need to deliver the first non blank cell above.

Thanks again

[zbor]

Here.. You only need to add space (not blank) in your red cells.