+ Reply to Thread
Results 1 to 2 of 2

Lookup and return Heading of column based on criteria (sample data attached)

  1. #1
    Registered User
    Join Date
    09-13-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    16

    Lookup and return Heading of column based on criteria (sample data attached)

    Uploaded more recent version of attachment
    Attached Files Attached Files
    Last edited by kai.; 04-30-2018 at 08:52 AM.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: Lookup and return Heading of column based on criteria (sample data attached)

    I just using your formula on column P and add more formula

    =IFERROR(INDEX($A$1:$L$1,MATCH(IFERROR(INDEX(INDEX(A2:L2,MATCH(EOMONTH(TODAY(),-1)+1,$A$1:$L$1,0)):L2,
    MATCH(1,INDEX(--(INDEX(A2:L2,MATCH(EOMONTH(TODAY(),-1)+1,$A$1:$L$1,0)):L2>0),),0)),""),A2:L2,0)),"")
    Attached Files Attached Files

+ 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. [SOLVED] Find value based on what the current month is (sample data is attached)
    By kai. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-30-2018, 08:32 AM
  2. [SOLVED] Lookup part number in column and return heading if found
    By Gorbs in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2015, 03:34 PM
  3. Lookup Value with merged cells (Sample Attached)
    By psingh2688 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2015, 08:58 PM
  4. Vlookup with multiple criteria (Sample workbook attached)
    By swade730 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2015, 01:20 PM
  5. [SOLVED] Whick lookup needed to return a column heading?
    By Thistledown in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-11-2014, 08:08 AM
  6. lookup values in a range,return corresponding column heading
    By aljaffa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2011, 04:31 PM
  7. Combining If and Lookup for Complicated Data (Sample is attached)
    By than_k22 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2010, 01:13 PM

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