EXCEL: Partial Cell matches in dfrnt sheets

Solved/Closed
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 - Jun 8, 2010 at 01:21 AM
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 - Jun 8, 2010 at 11:08 AM
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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jun 8, 2010 at 05:43 AM
you can use findall control F(edit find)
you need for each of the entries in column A of sheet 1 you need a macro. If you are oomforatable with macros post back

also confirm you are intersted in the first two words of the entries in column A of sheet 1

It would be useful if you can upload a very small extract of your fiels both sheet1 and sheet 2 through www.speedyshare.com with no passwod. You can use finctitious data for security reasons.
-1
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 12
Jun 8, 2010 at 11:08 AM
Macro would be very useful...

I can't upload any file from work...coz all these sites (like speedyshare) are blocked.
0