| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup data
I want to populate a table by referencing a cell range from another
worksheet, for example, if i type a name in a cell of worksheet1 i want to reference all the information corresponding to that name from a different worksheet -- Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup data
Assume MyR is a defined range (eg a 3C x 3R range)
In any other sheet, Suppose A1 will house the defined name: MyR Select an equivalent size range, say B1:D3 (with B1 active), paste into the formula bar, then array-enter by pressing CTRL+SHIFT+ENTER to confirm the formula: =IF(A1="","",INDIRECT(A1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "JRam" wrote: I want to populate a table by referencing a cell range from another worksheet, for example, if i type a name in a cell of worksheet1 i want to reference all the information corresponding to that name from a different worksheet -- Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup data
That works very well!!
-- Thank you "Max" wrote: Assume MyR is a defined range (eg a 3C x 3R range) In any other sheet, Suppose A1 will house the defined name: MyR Select an equivalent size range, say B1:D3 (with B1 active), paste into the formula bar, then array-enter by pressing CTRL+SHIFT+ENTER to confirm the formula: =IF(A1="","",INDIRECT(A1)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "JRam" wrote: I want to populate a table by referencing a cell range from another worksheet, for example, if i type a name in a cell of worksheet1 i want to reference all the information corresponding to that name from a different worksheet -- Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup data
Delighted to hear that. Thanks for feeding back.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "JRam" wrote in message ... That works very well!! -- Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data based on data comparison | Excel Worksheet Functions | |||
| Lookup of data | Excel Worksheet Functions | |||
| how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
| data lookup | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
Linear Mode
