Results 1 to 7 of 7

Can you set array for Vlookup or Index/Match using Offset?

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    seattle, wa
    MS-Off Ver
    Excel 2010
    Posts
    37

    Exclamation Can you set array for Vlookup or Index/Match using Offset?

    Can't seem to figure this one out...

    A B C D
    Cust1 Cust2
    Invoice1 $50 $100
    Invoice2 $50
    Invoice3 $100
    Total $200
    Cust2
    Invoice4 $100
    Total $100
    Cust3
    Invoice10 $60
    Invoice13 $100
    Total $160

    From the above table, when I choose cust2 in D1, I want D2 to yield "$100" which is the total for customer2.

    I can find cust2 from Column A using match and then maybe create vlookup array with Offset function??

    Here's my failed attempt.
    '=INDEX(B:B,MATCH("TOTAL",OFFSET(ADDRESS(MATCH(D1,A:A,0),1,4,1),0,0,1000,1),0),1)

    Help me!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-16-2012, 12:03 PM
  2. Excel array formula, offset, index, match...
    By flippertie in forum Excel General
    Replies: 6
    Last Post: 03-17-2011, 09:42 AM
  3. Index, Match, Vlookup, or Offset?
    By karstens in forum Excel General
    Replies: 2
    Last Post: 01-24-2011, 12:46 PM
  4. offset,match,index & vlookup
    By mingali in forum Excel General
    Replies: 1
    Last Post: 01-17-2010, 12:31 PM
  5. Which to use - if, vlookup, match, index, offset, vba?
    By punsterr in forum Excel General
    Replies: 3
    Last Post: 06-07-2005, 02:42 PM

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