LOOKUP-esque Need on Libre Calc
I know I'm being lame (old), but how do I achieve this lookup between two workbooks on libre calc? All I want is to add the corresponding size from Workbook 2 to a third column on Workbook 1, based on a match in the id columns of both Workbooks....
Workbook 1:
| id | name |
|---|---|
| 1 | Product 1 |
| 2 | Product 2 |
Workbook 2:
| id | size |
|---|---|
| 2 | 12 x 10 |
| 1 | 8 x 15 |