Results 1 to 7 of 7

index lookup problem against 2 criteria (match)

Threaded View

Heinrich Venter index lookup problem against... 09-28-2014, 07:06 AM
martindwilson Re: index lookup problem... 09-28-2014, 08:18 AM
Heinrich Venter Re: index lookup problem... 09-28-2014, 08:43 AM
martindwilson Re: index lookup problem... 09-28-2014, 08:54 AM
Heinrich Venter Re: index lookup problem... 09-28-2014, 09:14 AM
Heinrich Venter Re: index lookup problem... 09-28-2014, 09:35 AM
martindwilson Re: index lookup problem... 09-28-2014, 09:41 AM
  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    16

    index lookup problem against 2 criteria (match)

    Hey guys.

    I upgraded from Excel 2003 to 2013 Pro and I used this exact code to do my lookup and it worked.

    =INDEX('[Trend lookup Oct 14.xls]VB SCRIPT'!C$2:C$183,MATCH(A13&E13,INDEX('[Trend lookup Oct 14.xls]VB SCRIPT'!A$2:A$183&'[Trend lookup Oct 14.xls]VB SCRIPT'!B$2:B$183,0),0))
    Now it gives me all sorts of problems.

    Please have a look at the attached screen shot.

    If the screen shot could not be viewed the error states:




    We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it...........

    Not trying to type a formula?
    When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:

    you type: =1+1, cell shows: 2
    To get around this, type an apostrophe (') first:
    you type: '=1+1, cell shows: =1+1




    Hope you guys can help me.

    Thank you.
    Attached Images Attached Images

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: 04-30-2014, 02:42 AM
  2. Index/Match for a lookup involving 2 criteria
    By OilMan in forum Excel General
    Replies: 8
    Last Post: 10-30-2011, 07:07 PM
  3. Multiple Criteria Lookup/Match/Index
    By Kasz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2011, 09:30 AM
  4. Help with Lookup/match/index with 2 criteria.
    By Fizziii in forum Excel General
    Replies: 5
    Last Post: 04-28-2011, 10:00 AM
  5. Lookup Or Index, Match then Sum with several criteria.
    By borissinga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2010, 08:31 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