Hi
a formula approach: On sheet two in cell B1 enter
=IF(A1="","",VLOOKUP(A1'sheet1'!$A$1:$B$100,2,0))

if cell A1 on sheet two contains your manually entered
number/value

-----Original Message-----
Hello,

i would like to do a simple thing :

in sheet1, i have a colum with numbers in it and a column
with some
comments for each number.

in sheet2, i would like to automatically copy the
information of the
"comments" column when i enter in a cell one of the
number present in
the sheet1.

how can i do that ?

fabien
.