Finding next value down if cell is blank

[Bojack85]

Hi guys, Ive searched this forum a fair bit for the answer but I couldn't find it.

I have the following data set below and in Column G I would like it would like it to take a look and column D and if that cell is blank take the next cell down that has a value.

So for example if G2 to G4 it would return the value in D4 (£40,051.20) . Then from G5 to G9 it would return £31,318 etc

Is this possible?

 

[jasonb75]

With a dash in column D, I suspect that it has a value of 0, it is certainly not blank or empty.

Try this in G2, then fill down to the end of the data.

=IF(D2=0,G3,D2)

 

[Bojack85]

With a dash in column D, I suspect that it has a value of 0, it is certainly not blank or empty.

Try this in G2, then fill down to the end of the data.

=IF(D2=0,G3,D2)

Perfect! thanks so much

This worked