It's called VLOOKUP and I've an article on it he
http://www.officearticles.com/excel/...soft_excel.htm

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"stremetzky" wrote in message
oups.com...
On sheet1 I have the following data:

A B
111 NAME_1
222 NAME_2
333 NAME_3
444 NAME_4
.... ...

On sheet2 I'd like to link certain cells so that when I write in one
cell »111«, for example, I want in the cell beside to appear NAME_1.

Tnx for help,
stremetzky