+ Reply to Thread
Results 1 to 2 of 2

Vlookup within Vlookup

Hybrid View

  1. #1
    Registered User
    Join Date
    09-29-2010
    Location
    fasdasd
    MS-Off Ver
    Excel 2007
    Posts
    2

    Vlookup within Vlookup

    Hi guys,

    Here's what my data looks like: (ignore the '.' - I'm putting it in to make the columns line up)

    company day return
    a...............1..........1%
    a...............2..........3%
    a...............3...........-5%
    a...............4..........1%
    a...............5..........2%
    b...............1...........1%
    b...............2............2%
    b...............3...........3%
    b...............4............5%
    b...............5............6%

    And I want to create a smaller table based off this data,

    company day return
    a.................2.............?

    e.g. show me company a's return on day 2

    I've been trying to use this formula:

    =VLOOKUP(B13,INDIRECT(VLOOKUP(A13,A1:C7,3,FALSE)),3,FALSE)

    I was trying to tell excel to first find all the company codes in the main data sheet, then match the day in order to give me one return number. This formula just gives me a #REF! error though

    I'm running excel 07, windows vista just in case that's important to know.

    Is there someway to combine multiple vlookups within the one formula?

    Thanks!
    Last edited by xyr; 09-29-2010 at 01:55 AM.

  2. #2
    Registered User
    Join Date
    09-29-2010
    Location
    fasdasd
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Vlookup within Vlookup

    Actually, I think I've worked out what to do:

    Index + Match seems to do what I'm requiring.

    =INDEX($C$2:$C$7,MATCH($A15&$B15,$A$2:$A$7&$B$2:$B$7,0),0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1