At work I am constantly using VLOOKUP to compare one long list to other lists
to determine common elements or differences between the lists. I need a
simple function that will let me input two lists (named ranges?) and an
argument to output items in the first list that are common to the second
list, or items that are not common. In other words, I think, the ability to
AND the lists or OR the lists, to use Boolean terms. The final argument
would probably have to be an output range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Kind regards,

Niek Otten

"JerryMatson" wrote in message
...
At work I am constantly using VLOOKUP to compare one long list to other
lists
to determine common elements or differences between the lists. I need a
simple function that will let me input two lists (named ranges?) and an
argument to output items in the first list that are common to the second
list, or items that are not common. In other words, I think, the ability
to
AND the lists or OR the lists, to use Boolean terms. The final argument
would probably have to be an output range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions