ExcelBanter - two databases, only display info if NOT in each list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - two databases, only display info if NOT in each list (https://www.excelbanter.com/excel-discussion-misc-queries/192315-two-databases-only-display-info-if-not-each-list.html)

jrozendaal

two databases, only display info if NOT in each list

i have two worksheets showing people's info (DB1 & DB2):

A B C D E
F G
1 First Last Address 1 Address 2 City State Zip

2

3

on the third worksheet (DBmail), i only want to display mailing
addresses if the contact is NOT listed in BOTH DB1 & DB2. So if
sally's info is on DB1 and not on DB2, show her info. if Sally is on
both lists, do not show her info.

Let me know if you need any further clarification.

Any help is greatly appreciated! Thanks!

[email protected]

two databases, only display info if NOT in each list

anyone out there who can help?

[email protected]

two databases, only display info if NOT in each list

On Jun 24, 8:47*am, wrote:
anyone out there who can help?

nevermind, i figured out a way to do it.

All times are GMT +1. The time now is 09:29 AM.