Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple cell values to be drawn from single cell/id.
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up multiple values for a single name | Excel Worksheet Functions | |||
How can I enter multiple paragraphs in a single Excel cell? | Excel Discussion (Misc queries) | |||
Can I run Excel LookUp on a single cell through multiple sheets | Excel Worksheet Functions | |||
How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) |