How to get the row of a specified cell content

F

fabe

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
 
F

Frank Kabel

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
 
C

Chip Pearson

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
 
Top