compare different workbooks

[kjstec]

I have two workbooks from different programs which I imported to Excel. I
need to compare them to see what clients are on/off the lists. Some clients
have duplicate names because they have two different tests and I only want
to count them once to compare them to the other list to make sure they are on
that list.

Overall, I want to know if each client is on both lists and if not to to
make another list for the clients that are not on both lists.

Thanks,
Kathy

 

[CLR]

The VLOOKUP feature will check a cell against a list to see if it matches,
but will not find Thomas Jones if you look up Tom Jones, and vice
versa.........comparing lists from different sources is a bit of a problem
because they don't usually format everything the same.


Vaya con Dios,
Chuck, CABGx3