Need a formule for this....

Hello everyone,

I want to find a particular phrase, say for example a street address to be found from an entire Sheet.
i.e: If I have "8,Turner Rd, Bandra." in a cell somewhere on Sheet 1.
I want to have the Value or Number on "Column A" of the corresponding cell on Sheet 2.

Whats the formula to find it???

>The reason I need this is because I have about 500 street address on an Excel and I receive a raw file of bills from various companies which are located at different places.
>The excel I have, has the Name of the company in Column A and their addresses in Column B, one address below the other (ex: Sheet X).
>I have the Name of the Companies from "A1"-"Z1" on another sheet (ex: Sheet Y).
>Now what I want to do is...If the raw sheet that i receive has contains the street address in my list then the bill number should u listed under its particular Company name on Sheet Y.

Thanks in Advance....

Jerin John