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,,