Need formula to update duplicate value

[rskfriends]

Hello Friends,

I need some help.
Please see attached spreadsheet.

Need formula to update duplicate value.

[daffodil11]

C2:

=IFERROR(LOOKUP(2,1/(($A$2:$A$28=A2)*($B$2:$B$28<>"-")),$B$2:$B$28),"-")

and copy downwards

[rskfriends]

Hi daffodil11

Thank for your replay & valuable time for my query.

It works perfect

[daffodil11]

Thanks for the feedback, glad I could help.