comparing lists
 

I have two lists with names and phone numbers. How can I search one list
against the other for all the matching records?

comparing lists
 

You can use conditional formatting to highlight colours in one list that
appear in the other:
Example:
If you want to match B1:B5 against A1:A5

You did not include your version number. These instruction apply to XL2003


Click on B1.
Click Format, Conditional Formatting
Change condition 1 to 'Formula is'
Enter the formula =MATCH(B1,$A$1:$A$5,0)0
Click the format button
Choose your background colour
Click OK, twice
Copy B1
Highlight B1:B5
Click Edit, Paste Special, select Formats, click OK.

To highlight matching values in column A, do the reverse.

There is an alternate method that will do everything in one step but the
alternative will highlight two matching values in column one despite no
corresponding values in column 2.

For Excel 2007, the following shows how to add conditional formatting

http://www.homeandlearn.co.uk/excel2...l2007s6p2.html

The above Match formula should apply.

--
Steve

"brian" wrote in message
...
I have two lists with names and phone numbers. How can I search one list
against the other for all the matching records?

comparing lists
 

brian;337500 Wrote:
I have two lists with names and phone numbers. How can I search one
list
against the other for all the matching records?

you can use vlookup or Index/match to sort out the problem .......
but sample sheet will be more helpful to guide you properly


--
mubashir aziz
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=94381