Excel formula maybe Vlookup?

Ok so this is what I want to do but I want a formula(I think it might be =Vlookup maybe?) I know thhe process but am quite new to excel so any help would be appreciated.

If the value of cell B2 is ANYWHERE ELSE in that column and has a value in the same row but next column(C2) take the value in column D in the same row and put it in the original row’s (i.e row 2) column E.

Thanks for having a look!