Am currently working on a spreadsheet in which i will require three
cells' worth (from the same column) of information to be recognised by
a single number/id.

For example
A1 - 101
B1 - Surname
C1 - First Name
D1 - Salary

Does anybody know of any possible way to make it so that by typing A1's
value (101), the data from B1,C1,D1 all appear vertically?

Also, if it were possible to get this working across multiple
worksheets.

Would really appreciate any help possible with this thread.


--
El Shish
------------------------------------------------------------------------
El Shish's Profile: http://www.excelforum.com/member.php...o&userid=37710
View this thread: http://www.excelforum.com/showthread...hreadid=573007