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.