How do I join two tables with LibreOffice Calc?

I have two tables, each in it’s own sheet in the same file:

Name Age  
Alice 18  
Bob 19  
Carol 20
Dave 19    

Name Gender  
Bob Male
Dave Male
Eve Female

I want to automatically create a third table (sheet) that contains the joined data on the column name:

Name Age Gender  
Bob 19 Male
Dave 19 Male   

edit for readability by @karolus

Is this operation supported in LibreOffice Calc?


Formula in C2 of Sheet1:

=VLOOKUP(A2; Sheet2.$A$2:$B$1000;2;0)

pull down the Formula

What do I put into A and B?