Link to a row of another worksheet?

[cpliu]

The way I arrange my books record in Excel is have different categores
in different worksheet.
Information about each book is in one row. Sometimes one book may
belong to multipel categories. Is there a way to link the books from
another worksheet instead of copy-and-pasting the row from aonther
worksheet?

Thanks,

cpliu

 

[glen.e.mettler]

The way I arrange my books record in Excel is have different categores
in different worksheet.
Information about each book is in one row. Sometimes one book may
belong to multipel categories. Is there a way to link the books from
another worksheet instead of copy-and-pasting the row from aonther
worksheet?

Thanks,

cpliu

Have you tired MATCH() or VLOOKUP()?

Glen