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

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

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

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