Automaticaly text search and pase into another sheet in excel

[mirza5313]

hello folk

I am search a method for excel macro for automatically text search and paste.

I have one sheet called Master list in which i have two column Part number and second nomenclature, and i required to search part number with nomenclature.
like that

A
Part Number
A2-ZO-67


B
Nomenclature
Telephone

and like that almost 2800 records,

now i want in sheet 2 to paste some nomenclature and then automatically search their part number from sheet 1,
and also search if nomenclature is reverse like set radio and other many example.

please help me in this regards,