Formula needed. If I write a specific name then I want the corresponding part number to fill

[kmurph]

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,

[ArviLaanemets]

The info on other worksheet must be in table (all info about particular person is single row, the key column (e.g. name) must be leftmost one.

You can get any info for this person from persons table (e.g. part name) using VLOOKUP() function.