How to set cell value automatic in excel

i have a table like this

i need when add (Name) check if already exist then if true fill (Per-H) automatically

if Name is not yet in the list, then it will be a new entry to manually input values