Ask Your Question

How do I join two tables with LibreOffice Calc?

asked 2016-12-28 00:15:30 +0100

christankl gravatar image

updated 2016-12-29 11:28:41 +0100

karolus gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-12-29 11:34:38 +0100

karolus gravatar image

updated 2016-12-29 11:36:55 +0100


Formula in C2 of Sheet1:

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

pull down the Formula

edit flag offensive delete link more


What do I put into A and B?

christankl gravatar imagechristankl ( 2016-12-29 23:20:58 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-28 00:15:30 +0100

Seen: 1,691 times

Last updated: Dec 29 '16