I have two worksheets. I want to do a formula whereby IF I write a specific name in one column, then it will automatically enter the data from the previous worksheet relating to that specific name. I hop that makes sense lol

For example. On worksheet one I have the Part Names. One is Mitto Remote. Mitto Remote then has a corresponding Part Number. If on worksheet two, I write Mitto Remote then in the next cell I want to part number from the first worksheet to automatically fill.

Thank you so much for any help,