I missed that you wanted to increment the row, not the column.

One way:

C1: =$A2+INDEX($B:$B,COLUMN()-1)

Note however, that given your sample data, you'll only get #VALUE!
errors, since the + operator requires two numeric values, not text.

Did you mean to concatenate (&) instead?


In article , Jonah
wrote:

No luck there. Any other thoughts