+ Reply to Thread
Results 1 to 4 of 4

Index and match between to cells of data in the same row

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 365
    Posts
    114

    Index and match between to cells of data in the same row

    Hello all, good afternoon

    Im looking for some help on matching 2 cells of data to show a value from a different sheet within the workbook. Currently i have the below formula to match a certain criteria and this works,
    =INDEX('TREE BAG P+L'!A3:BA3,MATCH(VLOOKUP('TREE BAG P+L'!BB3,'SKU# DATA'!$B$1:$C$6,1,0),'TREE BAG P+L'!$A$2:$BB$2,0))

    But what im trying to do now for example is
    if A2 is C2 in sheet 1, then it needs to be "X cost" associated to those 2 values but match a different field

    If you look at my example you can see what I'm indexing and see what I'm trying to achieve.

    Thanks for your time
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Index and match between to cells of data in the same row

    Try this formula in D2

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 365
    Posts
    114

    Re: Index and match between to cells of data in the same row

    That is close. It works for that particular match
    I would have to change it all the time though. The end of the formula shows +3 which worked great for the 1 row... others would have to be +4 or +2. The values that it matches are not always +3

  4. #4
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 365
    Posts
    114

    Re: Index and match between to cells of data in the same row

    I figured it out-
    I just added another column to match the index value and used my first formula and it worked perfect...
    Thanks all for looking

+ 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] Index match - not returning data (for all cells)
    By rayted in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-06-2017, 07:41 AM
  2. Creating INDEX MATCH MATCH formula based off text in cells
    By bbkdude in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-26-2017, 10:37 AM
  3. [SOLVED] INDEX/MATCH to return cells 4 & 5 places below my Match...
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-19-2017, 07:56 AM
  4. [SOLVED] INDEX/MATCH or Equivalent to Return Data with Blank Cells
    By bcathell in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-28-2017, 01:57 PM
  5. [SOLVED] Help with Index/Match using numbers from two cells for the match.
    By dtexter in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-13-2017, 05:42 PM
  6. [SOLVED] Link data validation to other cells, index match
    By chance0410 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2013, 03:49 AM
  7. INDEX and MATCH functions to sum data with blank cells
    By Simplex06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2013, 08:38 AM

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