Results 1 to 4 of 4

INDEX and MATCH problem

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Zürich
    MS-Off Ver
    Excel 2007
    Posts
    9

    INDEX and MATCH problem

    Hi there, I'm trying to update a template for work that deals with order release. The step I'm currently having problems with is trying to index the current backlog to the previous days backlog using two cells (Sale Order Number and Line Number) as the index. The old template I'm working off was used in Excell 2003 format.

    I've attached the worksheet I'm trying to update. My problem is the formula in cell L2 of the BLQ tab, and the forumla looks like this:

    =INDEX('NEW BLQ'!$I$2:$I$1000,MATCH(A2&B2,'NEW BLQ'!$D$2:$D$1000&'NEW BLQ'!$E$2:E$1000,0))

    Basically I want to index (in this case) the request date on the new backlog (New BLQ tab, column I), against the request date on the old backlog (unsurprisingly called the Old BLQ tab) using Cell A2 (Sales order) and B2 (Line number) to match the values. This means when I paste the order backlog information into columns A to E, it will auto-populate from columns L to AB using a similar reference formula.

    I copied over the formula from the old worksheet and corrected the tabs, but instead of returning a date I get #VALUE.

    I don't know if it's significant, but the formula on the older worksheet has additional parenthesis which I'm not sure the significance of.

    {=INDEX('NEW BLQ'!$I$2:$I$1000,MATCH(A2&B2,'NEW BLQ'!$D$2:$D$1000&'NEW BLQ'!$E$2:E$1000,0))}

    I appreciate any help - thanks!
    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. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  2. Index,Match problem...
    By kmc500 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2012, 10:45 AM
  3. index & match Problem
    By pecsin in forum Excel General
    Replies: 2
    Last Post: 07-14-2012, 02:24 AM
  4. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 PM
  5. Match and index problem
    By wonderdunder in forum Excel General
    Replies: 2
    Last Post: 04-19-2011, 02:48 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