Search using a Word/Phrase

Hi Team/All,

Need some help, I have a sheet ful of materials, I would like to create a macro in Excel in which a person would enter the word/phrase and the macro would find the materials containing those/that phrase. It would be great if it would be something like the VLOOKUP formula, in stead of the whole word it searches for the part of the phrase.

Example....

Suppose one of the Material is
ELBOW 90 S80 CPVC 2" PART#9806-020
ELBOW 90 S80 CPVC 3" PART#9806-030
ELBOW 90 S80 CPVC 4" PART#9806-040

then if i give 9806-020, then it should give me "ELBOW 90 S80 CPVC 2" PART#9806-020", but if i give just 9806 then it should give me all the materials.

It would be great if you could help, waiting for your response as early as possible.

Hitesh

I