Results 1 to 17 of 17

Index match formula unable to arrive a formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    239

    Index match formula unable to arrive a formula

    Hi

    Please find excel template

    I need to extract values using index match both rows and colums

    ist sheet is having the master data
    2nd sheet i would like to extract the data o by using index and match
    I indent to use for extracting for bringing non blank and non zero values to extract of dues dates of payment due dates schdule of parties
    The formula given in 2nd sheet is not working
    I am trying to use match and index instead of vlookp since it will handle multiple values

    Please help.
    Thanks & Regards
    N.Srinivasan
    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] Index Match Formula doesn't recognize output from Right Formula as lookup value.
    By GoGators in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 11:33 AM
  2. [SOLVED] Index, Find, Row Formula to arrive at the results
    By sjpras in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-20-2015, 01:43 AM
  3. Unable to arrive at dynamic & automated alternative to manual find & replace process
    By calantha in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-19-2013, 03:55 AM
  4. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 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