Results 1 to 4 of 4

Multiple lookup

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-21-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    186

    Multiple lookup

    Gurus,

    I am building a calendar and trying to figure out what I am doing wrong with multiple events showing up on the same day.

    Please see attached file.

    on Aug 22, the formula used only sees the first event. I understand why

    However, on Aug 23, the formula isn't working as it is not getting any data.

    Formula in Cells H22 : H25 was setup as an array.


    {=IFERROR(INDEX($P$3:$P$300, SMALL(IF($H$21=$O$3:$O$300, ROW($O$3:$O$300)-MIN(ROW($O$3:$O$300))+1, ""), ROW()-2)),"")}

    The result I want is shown below "Goal".

    TIA!

    Overmyhead,

    Tim
    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. [SOLVED] Lookup multiple criteria in multiple columns in multiple rows; return true if exists
    By ufdlim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 02:03 PM
  2. Lookup table help - multiple returns for one lookup value
    By radddogg in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-16-2016, 02:22 PM
  3. Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  4. Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  5. [SOLVED] Multiple lookup adding columns, then multiplying, then lookup, add, and subtract
    By mamig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 12:55 AM
  6. Lookup adjacent column to multiple lookup columns.
    By JAMES4228 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2009, 03:19 PM
  7. Replies: 3
    Last Post: 10-10-2005, 01:05 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