vlookup + match formula

[supernovartis]

Hi folks,

I have a problem with the attached excel file. I have some value sorted numerically (according to ID column) but there are some missing values. In a new column (Desired value column), I would like to return the values (according to ID column) and add missing values (according to Order column) as zero.

I know this can be done with vlookup and match but I cannot figure out how.

Any ideas?

Thanks a lot.