ID     Name
1      Prod 1
2      Prod 2
3      Prod 3
4      Prod 4
5      Prod 5
6      Prod 6

ID     Name
1      Prod 1
2      Prod 2
4      Prod 4
6      Prod 6

S1:              S2:
ID     Name       ID     Name
1      Prod 1     1      Prod 1
2      Prod 2     2      Prod 2
3      Prod 3     N/A    N/A
4      Prod 4     4      Prod 4
5      Prod 5     N/A    N/A
6      Prod 6     6      Prod 6

=S1!A2 and =S1!B2

=LOOKUP(A2,S2!$A$2:$A$30)