EXCEL: Partial Cell matches in dfrnt sheets

Hello,

I searched a lot and found quite some useful results about searching Partial Cell matches. But if the cells belong to different sheets how do I match them?
For example,

Sheet 1,
A4483 Al Ghandi Electronics

Sheet 2,
A752 Al Ghandi Auto
A753 Al Ghandi General Trading

I want to match the first two words (or first 8 characters) in Sheet1, A4483 with all cells in sheet 2 Column A.

If possible multiple matches will also be good. For now only one will do.
The return needs to be Al Ghandi Auto or both Al Ghandi Auto & Al Ghandi General Trading.

I tried V Look up...its not much of use...character matching would be good I guess.

Any help will be appreciated....kinda urgent