Nested functions using array/range names
 

Is it possible to write a nested formula such that the result of the first
calculation is an array that is used in the 2nd formula?

I have a formula:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

that is nested in an index formula, INDEX(array,row_num,column_num), to
result in:

INDEX(VLOOKUP(lookup_value,table_array,col_index_n um,range_lookup),row_num,column_num)

I want the result of the Vlookup to be a range name or an array that the
Index formula will accept. How do I do this?

I am using Excel 2003.

Nested functions using array/range names
 

Think you could try using INDIRECT, indicatively:
=INDEX(INDIRECT(vlookup(..)), ...)
where the vlookup returns the named range
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"bearspa" wrote:
Is it possible to write a nested formula such that the result of the first
calculation is an array that is used in the 2nd formula?

I have a formula:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

that is nested in an index formula, INDEX(array,row_num,column_num), to
result in:

INDEX(VLOOKUP(lookup_value,table_array,col_index_n um,range_lookup),row_num,column_num)

I want the result of the Vlookup to be a range name or an array that the
Index formula will accept. How do I do this?

I am using Excel 2003.

Nested functions using array/range names
 

Seems so:
=INDEX(INDIRECT(VLOOKUP(M12,RangeNamesList,2,FALSE )),3,2)

RangeNamesList is a 2-column named range with the names of other named
ranges in the second column.
M12 contains the value to be looked up in the 1st column of
RangeNamesList.

Worked here.

bearspa;438747 Wrote:
Is it possible to write a nested formula such that the result of the
first
calculation is an array that is used in the 2nd formula?

I have a formula:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

that is nested in an index formula, INDEX(array,row_num,column_num),
to
result in:

INDEX(VLOOKUP(lookup_value,table_array,col_index_n um,range_lookup),row_num,column_num)

I want the result of the Vlookup to be a range name or an array that
the
Index formula will accept. How do I do this?

I am using Excel 2003.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121745

Nested functions using array/range names
 

Thanks to both Max In Singapore, and p45cal for your responses. Your
approach worked for me---plus I learned about the "indirect" function.

I have marked both your responses as "the answer", and I hope the system
accepts it.

"p45cal" wrote:


Seems so:
=INDEX(INDIRECT(VLOOKUP(M12,RangeNamesList,2,FALSE )),3,2)

RangeNamesList is a 2-column named range with the names of other named
ranges in the second column.
M12 contains the value to be looked up in the 1st column of
RangeNamesList.

Worked here.

bearspa;438747 Wrote:
Is it possible to write a nested formula such that the result of the
first
calculation is an array that is used in the 2nd formula?

I have a formula:
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup)

that is nested in an index formula, INDEX(array,row_num,column_num),
to
result in:

INDEX(VLOOKUP(lookup_value,table_array,col_index_n um,range_lookup),row_num,column_num)

I want the result of the Vlookup to be a range name or an array that
the
Index formula will accept. How do I do this?

I am using Excel 2003.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121745

Nested functions using array/range names
 

Welcome, glad you got it going over there
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"bearspa" wrote in message
...
Thanks to both Max In Singapore, and p45cal for your responses. Your
approach worked for me---plus I learned about the "indirect" function.

I have marked both your responses as "the answer", and I hope the system
accepts it.