EXCEL: Partial Cell matches in dfrnt sheets [Solved/Closed]

Report
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
-
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
-
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
792
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.
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
12
Macro would be very useful...

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!