Q:

How to lookup values and insert contents between two spreadsheets?

I have to manage a lot of information in Excel. I have two spreadsheets in one workbook. The first one shows different names on the second row (Abasolo TAMPS 1, Abasolo TAMPS 10, etc) and the second one shows also names (Column A) but next to them there are also some parameters like Wind Speed, Distance, X and Y (Column B). Does any one know how to programm in VBA a way to tell Excel to take the first value on the column A (Say Abasolo, TAMPS 17) on the second spreadsheet (image of the right), look them up in the second row of the first spreadsheet (image on the left), take the set of parameters next to the name and insert them on row 11 and the intersecting column on the first spreadsheet (image of the left, where the "2's" are). That for all the values on column A of the second spreadsheet.

A:

You can VLOOKUP to achieve this. 
Sheet 2 parameters

Sheet 1 VLookup

I used the function
=VLOOKUP(B$4,Sheet2!$A$2:$B$3,2,FALSE)

in Cell B6 on sheet1.
To maintain line breaks, you will need to ensure wrap text is used for the destination cells as shown below

You can read more about VLOOKUP here.
VLOOKUP

