Nested functions using array/range names

B

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.
 
P

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.
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top