Get data from 1 s-sheet into another.ods (14. I was thinking this might be done using lookup tables but I have never used them before and reading about them, it seems that it might not be a solution.

What I want a formula/function to do is to find the catalog number (col A) in the source spreadsheet and then extract the corresponding ID number (col B) into the correct row in the destination spreadsheet, next to the destination spreadsheet's catalog number column. The ID number is next to to the column of data that both spreadsheets have - this is a catalog number. Furthermore, the destination spreadsheet also has data that the source does not. In addition, some data has long been deleted in the destination spreadsheet making it tricky/unreliable to do a simple copy and paste between the two spreadsheets. This is needed just the first time you launch Apache OpenOffice. If prompted, enter an administrator name and password. Select Open from the top of contextual menu that appears. However, one spreadsheet (I'll call it the source) has a column of data (an ID number) that the other doesn't have (I'll call that one the destination). For macOS 10.12 'Sierra': In Finder, Control-click or right click the icon of the app.

They both have about 3500 rows and 26 columns.

I have two spreadsheets that are close to being identical.

Openoffice for macos