Hello all, new member and i need some help.

I compile custoemr impact on excel spreadsheets for work. We have a
list of critical customers that egt special attention. What i am trying
to do is come up with a way to crossreference the val;ues from 2
different sheets without havign to maually data sort.

The values will not be exactly the same so i would like to set it up so
that if the first x amount of characters are the same it will match. The
sheets are both alphabetical in ascending form. My Critical list is a
constant. My customer list will vary depending on the outage. The only
pertinant data will be in column A on both sheets.

as an example:

my current sheet would be something like:

cell A3: *bobs tires (customer id xxx)*
my critical list iwould be
cell a1: *bobs tires*

So what i would like to do is set up something so that recognizes these
2 cells as being the same, and will reflect on the current sheet as
critical with something like Bolding the custoemr name, or changing the
font to red etc.

Thanks in advance, if you need any more info please let me know.

Mike P



--
wolfsburg2
------------------------------------------------------------------------
wolfsburg2's Profile: http://www.excelforum.com/member.php...o&userid=29866
View this thread: http://www.excelforum.com/showthread...hreadid=495703