1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel question re nested functions

Discussion in 'Business Applications' started by Bearspa, Aug 2, 2009.

Thread Status:
Not open for further replies.
  1. Bearspa

    Bearspa Thread Starter

    Joined:
    Apr 5, 2004
    Messages:
    96
    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'm using Excel 2003.
     
  2. turbodante

    turbodante

    Joined:
    Dec 19, 2008
    Messages:
    744
    AFAIK VLOOKUP will not be able to return a range; instead, perhaps you could solve the problem by devising a way to return the top left and botton right cells of your target range - then you can combine using INDIRECT?
     
  3. Bearspa

    Bearspa Thread Starter

    Joined:
    Apr 5, 2004
    Messages:
    96
    Thanks, turbodante, for telling me about the "INDIRECT" function. I looked it up, and it works perfectly.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/848481

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice