Nested functions using array/range names

[bearspa]

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,range_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_num,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.

 

[Max]

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

 

[p45cal]

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

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

Worked here.

 

[bearspa]

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.

 

[Max]

Welcome, glad you got it going over there
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik