Using a Vlookup on the additions sheet might be the answer...

Add a column on the left side of you master sheet with the left most 10
characters in the name.

On the additions sheet, use Vlookup to find the value in the first column of
the master sheet and return the value one column over(col_index_num = 2).
Make sure you set range_lookup to False to require an exact match. If the
addition is not in the master list, Vlookup will return #N/A.

Regards...

ChristopherTri



"rapid1" wrote:

I'm sure there's a simple answer for this, but I've searched for the better
part of 2 hours now and can't find what I'm looking for - any help will be
greatly appreciated! Anyway, I have 2 sheets that contain customer names -
one is a master list, the other new additions - I need to make sure there are
no customers on the new addition sheet that already exist on the master
sheet. Since the names may not be formatted the same, I used =LEFT to pull
out a portion of each name on the new additions sheet. What I can't figure
out is how to tell Excel to search the master sheet for the text in the
additions sheet.
Additions sheet:
F
2 ADVANCED I

Master sheet:
A
G
3580 123456 ADVANCED INDUSTRIAL SERVICES

So on the additions sheet I need to find ADVANCED I within column G on the
master and return the value for column A that corresponds to the name in G.

Did I evplain that okay?