suppose sheet 1 is
name email phone
a
d
g
sheet 2 is
name email phone
A
S
D
F
G
H
J
K
in sheet 2 in D2 copy this formula
=VLOOKUP(A2,Sheet1!$A$2:$C$101,1,0)
copy the formula in D2 down. wherever the data is not available in sheet will show #N/A
You can modify this solution to suit your needs
example:
=VLOOKUP(A2,Sheet1!$A$2:$A$101,1,0)*AND(B2,Sheet1!$B$2:$B$101,1,0)