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.

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.

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

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

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.