-1

Sorry, i can't use the right terms but i try to explain my task:

In Calc, or Spreadsheet I have two worksheets with columns like this:

|   ID|
|   32|
|   51|
|   51|
|   63|
|   70|

and 

|   ID|Name     |   
|   01|name1    |   
|   02|name2    |   
...
|   69|name69   |   
|   70|name70   |

i need to combine/assign/migrate these together, like:

|   ID|Name     |   
|   32|name32   |   
|   51|name51   |   
|   51|name51   |   
|   63|name63   |   
|   70|name70   |

I have no idea how can is start to solve it. Please help!

eapo
  • 1,053
  • 1
  • 19
  • 40
  • 4
    In excel, you can use VLookup. Some good examples here: http://www.excel-easy.com/functions/lookup-reference-functions.html – PhysicalChemist Jun 04 '15 at 19:56
  • Is the information on worksheet 2 in the form of a table or raw data, such as ID's in column A and Name's in column B? – Clif Jun 04 '15 at 19:57
  • @pnuts, Good one. Was going with the OP's terminology and assuming that the second graphic was what s/he was calling worksheet 2. – Clif Jun 05 '15 at 04:36

1 Answers1

0

Thank you @PsysicalChemist, the VLookup function is working in Calc to.

eapo
  • 1,053
  • 1
  • 19
  • 40