IF [find value in a column] THEN [copy value from a different column]

[Gabriel1]

Hi,

I have a spreadsheet with 10 columns. Column 1 has ID’s, the rest (2 trough 10) have data attached to that ID’s. Now I have a new column (column 11) where only some of the IDs in column 1 are present and not in order.

I want to attach in column 12 data present in column 2 and I need a way to search column 1 until the correct ID (ie: matching the ID in column 11) is found and when this happens, paste the data present in column 2.

Please tell me if I’m not being clear.

[Gabriel1]

I was looking for the VLOOKUP function: http://help.libreoffice.org/Calc/Spreadsheet_Functions#VLOOKUP