vlookup
Excel
Sheet1
A B C
id name desc
1 aa 1aa
2 bb 2bb
3 cc 3cc
Sheet2
A
name
aa
bb
cc
In sheet2, put in a vlookup to find desc from sheet1 by the name.
VLOOKUP(A2, Sheet1!$B$2:$C$3, 2, False)
The first A2 is the name from sheet2 which will used for searching
The Sheet1 indicates the sheet to be searched
The $B$2 : $C:3 means searching the table starting at B2 and ending at C3 (i.e. the top left and bottom right of the rectangle) in sheet 1.
The 2 means the second column in the search rectangle
The False means doing exact match
Note:
The search rectangle needs to start at the column which matches the name.
e.g. in the above example, if the search rectangle starts at A2, then it won't find anything, weird... seems starting right from the column that contains the name will work.
The bottom right should be set to sth big enough to include the whole sheet.