Hi Revipod, welcome to the forum.

Is your dad also your teacher? Why would your dad care whether or not a worksheet with a list of names and phone numbers a) has a search field; and b) starts finding names as you type them?

To get you started, worksheet cells don't have KeyUp, KeyPress, KeyDown events like form fields do. So you could create a UserForm in Excel to do this. Once you start typing into the search field on the UserForm, you could have the Key event start scanning for matches on a worksheet, and pull in a corresponding value into another field on the form.