How to get the row of a specified cell content
 

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

How to get the row of a specified cell content
 

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
.

How to get the row of a specified cell content
 

Fabien,

You probably want to use the VLOOKUP function. For example,

=VLOOKUP(A1,Sheet!A1:B100,2,FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"fabe" wrote in message
om...
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