It sounds like you could use =vlookup().

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Alec H wrote:



Hi,

I am creating a customer database in a Excel 2000 pro workbook. It
comprises
of multiple worksheets each containing a different companies details
(branc
hes, phone numbers, etc). I have ensured that in all sheets column A is
a nu
meric field and that each row has a unique number in this column
(unique acr
oss all sheets).

Where I have got "stuck" is that I want to create a additional
worksheet in
which I can manually designate a number in a cell (column A) and excel
will automatical
ly fill the remaining cells in that row from whichever sheet the number
corr
esponds.

Help please.....

--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=507154

--

Dave Peterson