Results 1 to 7 of 7

Index Function Not Working Properly

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    178

    Index Function Not Working Properly

    Hi, I have an Index Function
    =INDEX(A$1:F$1,MAX(IF(A$2:F$7=H2,COLUMN(A2:F7)-COLUMN(A2)+1)))
    that searches a table and returns the Column heading if it finds a matching name. The problem is that if it does not find a matching name it returns the Heading of the first Column instead of blank (""). Your help is appreciated. An explanation of how it works would be awesome as I am trying to learn as I go.
    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] Sumif with an index formula not working properly
    By Panfergrrl18 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2015, 12:49 AM
  2. [SOLVED] Max Function Not Working Properly
    By STU22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2015, 07:41 PM
  3. Index and Match across multiple rows and columns look up not working properly
    By jollyfella in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-09-2015, 12:06 AM
  4. [SOLVED] Multiple IF's & Index/Match - Not working properly
    By Pooger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-10-2015, 04:01 PM
  5. Day Function Not Working Properly
    By clh7837 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 12:51 PM
  6. Indirect function not working properly
    By zuri125 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2012, 01:40 PM
  7. sumproduct function not working properly
    By jls141 in forum Excel General
    Replies: 1
    Last Post: 04-27-2012, 03:15 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