Results 1 to 3 of 3

Index Match Issue with internal concatenation

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2010
    Posts
    28

    Angry Index Match Issue with internal concatenation

    Hello all,

    Fairly new using index match with excel. I've had success in the past, but it was a simpler formula. What I am trying to do is the following:

    Using "BPO Open Order Report" column "C" + "D" to look up against "Warehouse Receipts Report" where column "B" + "C" will pull in the various fields i need. I think my issue with the formula is that I am trying to concatenate within the formula instead of creating a separate column with the concatenation.

    The formula is in "BPO Open Order Report" in "O2", also posted here in case its a formatting issue.
    =INDEX('Warehouse Reciepts Report'!B2:H7,MATCH(C2&D2,'Warehouse Reciepts Report'!B2&'Warehouse Reciepts Report'!C2,0),2)
    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] Ignore concatenation in Index Match if cell is empty
    By MagicMan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-11-2019, 12:11 PM
  2. Replies: 1
    Last Post: 08-17-2019, 01:11 PM
  3. Replies: 6
    Last Post: 12-13-2017, 10:08 AM
  4. Issue: Only returning 1st match on Index/Match
    By tbr2891 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2014, 11:54 AM
  5. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  6. Vlookup/index/match + concatenation
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2013, 01:42 PM
  7. Index & Match with Concatenation
    By rickyilas in forum Excel General
    Replies: 2
    Last Post: 08-15-2011, 03:28 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