with the fourth Vlookup argument set to false (or 0), it should not matter
what order the tables are in as it will find an exact match (and return #N/A
if no match is found). I am assuming the email addresses are in the first
column of your table and yes/no is in the second column. Also, with text you
have to be wary that there are no trailing spaces as Vlookup will not
recognize a match with extra spaces in the data.


"Kent - Tech Evangelist" wrote:

thanks jmb,,

uuhmm,, as i tried it,, it doesnt work anymore if the email was arranged
differently,,

i.e. if was listed before ,,

"JMB" wrote:

With email address in A1,

=AND(VLOOKUP(A1,Table1,2,0)="yes",VLOOKUP(A1,Table 2,2,0)="yes")

and copy down.

"Kent - Tech Evangelist" wrote:

if a have two set of tables in two different sheets,,

i.e.

session1 - Table1(sheet1)
email Attend
yes
yes
no

session2 - Table2(sheet2)
email Attend
no
yes
no

can i create a new table at a new sheet showing me who didnt attend the two
sessions,,

help will be highly appreciated,,