+ Reply to Thread
Results 1 to 3 of 3

Need Index Match formula help

  1. #1
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Need Index Match formula help

    Index Match formula.xlsx
    The attached file has two worksheets: Invoice Log and Match.
    I need a formula for column G in the Match worksheet. It should look up the Doc # and give me the invoice number in the Invoice Log sheet that matches this doc number.

    The formula I used is: =IF($S5="","",IF($B5="Invoice Pmt",INDEX('Invoice Log'!$C$4:$C$90,MATCH($C5,'Invoice Log'!$AI$4:$AI$90),0)))
    As you can see in the Match sheet in cell G11 I am not getting the correct result. The formula should be returning the invoice numbers I manually entered in col AF (This column is just to show what the formula result should be. It will not be included in the final file.)

    Thanks for anyone who can tell me why my index match formula is not always working.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Need Index Match formula help

    a small modification to your formula
    g5=IF($S5="","",IF($B5="Invoice Pmt",INDEX('Invoice Log'!$C$4:$C$90,MATCH($C5,'Invoice Log'!$AI$4:$AI$90,0)),""))
    try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    10-11-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    230

    Re: Need Index Match formula help

    Perfect!!!!! 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. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  2. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  3. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  4. Index Match Index Formula work slow
    By avk in forum Excel General
    Replies: 9
    Last Post: 03-07-2012, 02:19 PM
  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