+ Reply to Thread
Results 1 to 3 of 3

Multiple Value Array Lookup

  1. #1
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Multiple Value Array Lookup

    Hello all,

    I am trying to write a function that will look up values in an array, and then return a value from a separate array. where:

    Column A has a name and dates:..Column B has a number associated with the date (0 or 1)

    "John" ..............................................0
    6/1 ..............................................0
    6/2 ..............................................1
    6/3... ..............................................0
    6/30 ..............................................1
    "Bill" ..............................................0
    6/1 ..............................................1
    6/2 ..............................................1
    6/3... ..............................................0
    6/30 .............................................. 1
    "Fred" and so on...................................0



    I am trying to make a summary table that shows the dates associated with each time "1" occurs

    So it will look like:

    column C: ...... Column D: ...... Column E:......Column F:
    John.................6/2...............6/30............... N/A
    Bill ............... 6/1...............6/2............... 6/30
    Fred ...............N/A ...............N/A...............N/A

    and so on:


    I've tried excel formulas, but can't get the right date returned, so I was hoping for some guidance on using VBA to have my own function


    Thank you!
    Last edited by betherzy; 07-14-2014 at 01:17 PM.

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    274

    Re: Multiple Value Array Lookup

    This seems like a strange request,

    Please Login or Register  to view this content.
    Cell usage example:
    Please Login or Register  to view this content.
    A B C D E F
    1 John 0 1 2 3
    2 6/1 0 John =StrangeLookup($C2,$A$1:$B$11,D$1) =StrangeLookup($C2,$A$1:$B$11,E$1) =StrangeLookup($C2,$A$1:$B$11,F$1)
    3 6/2 1 Bill =StrangeLookup($C3,$A$1:$B$11,D$1) =StrangeLookup($C3,$A$1:$B$11,E$1) =StrangeLookup($C3,$A$1:$B$11,F$1)
    4 6/3 0 Fred =StrangeLookup($C4,$A$1:$B$11,D$1) =StrangeLookup($C4,$A$1:$B$11,E$1) =StrangeLookup($C4,$A$1:$B$11,F$1)
    5 6/30 1
    6 Bill 0
    7 6/1 1
    8 6/2 1
    9 6/3 0
    10 6/30 1
    11 Fred 0

  3. #3
    Registered User
    Join Date
    06-16-2014
    Location
    Colorado
    MS-Off Ver
    2007, 2013
    Posts
    28

    Re: Multiple Value Array Lookup

    It may seem strange, but it is actually helpful! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple lookup value but not returning table array results
    By swannee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-14-2014, 02:12 PM
  2. [SOLVED] Lookup to return multiple results - without array
    By ZeDoctor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2012, 07:42 AM
  3. Array Lookup, Return/Sum Multiple Values
    By mre2000 in forum Excel General
    Replies: 3
    Last Post: 01-18-2010, 10:45 PM
  4. array/lookup help - multiple references over multiple colums
    By cards52 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2009, 03:04 AM
  5. multiple array reference with lookup combination
    By wolph42 in forum Excel General
    Replies: 3
    Last Post: 07-22-2008, 07:46 AM

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