+ Reply to Thread
Results 1 to 4 of 4

Index / match formula error

  1. #1
    Registered User
    Join Date
    06-20-2015
    Location
    Chennai, India
    MS-Off Ver
    2010
    Posts
    59

    Index / match formula error

    Dear All,

    Anyone would you please help me on the below formula.

    In the attachment, I need to get the exact value for each cell in 'Dashboard' tabs.. based on two values;

    D4 = Combination of 'C4' & 'D2' + Goto 'BuyData' tab; If the values of Col B (should match Dashboard:C4) & Col C (should match Dashboard:D2) matches with 'Dashboard' tab then we have to pull the 'B.Qty' (col E)

    I have filled some sample expected value...

    It would be grateful if you could help me to find a formula for this.

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Index / match formula error

    with a helpcolumn.

    see the green cells for the result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Index / match formula error

    Hi

    D4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Copy down
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  4. #4
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,292

    Re: Index / match formula error

    Probably you need to do so?
    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] If error index match formula help
    By shrubfact in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 05-03-2015, 05:52 PM
  2. [SOLVED] Getting error in index-match formula
    By mso3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-11-2015, 10:17 AM
  3. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  4. error in index+match formula
    By j_r_m_c in forum Excel General
    Replies: 5
    Last Post: 02-14-2011, 04:30 PM
  5. Index & Match (Formula Error)
    By rickyilas in forum Excel General
    Replies: 2
    Last Post: 02-26-2010, 11:10 AM

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