=if & index

[Ra21V12eN]

I'm trying to construct a formula which contains an =IF and what I think needs to be INDEX, but cannot be 100% certain as I've never done.

I can't post a sample of the workbook due to company policy, but here's what I'm trying to do:

In Cell b2

=if(a2<>"",get the first instance of a non zero number from column D to column infinity and put it in this field, otherwise put a 0)

Thank you in advance!

Chris