+ Reply to Thread
Results 1 to 2 of 2

2 dimension lookup not working

  1. #1
    Forum Contributor
    Join Date
    01-16-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    136

    2 dimension lookup not working

    Hi Im trying to get the cash weight on the attached by looking up to the attached. But its only working for some lines.

    Any help much appreciated

    JB
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,293

    Re: 2 dimension lookup not working

    =INDEX('Model Weights'!$B$3:$D$9,MATCH(B2,'Model Weights'!$A$3:$A$9,0),MATCH(D2,'Model Weights'!$B$2:$D$2,0))

    Try this one
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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] Dimension Arguments?
    By ww2u in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-11-2013, 01:39 PM
  2. [SOLVED] 2 dimension lookup
    By kl99ny in forum Excel General
    Replies: 7
    Last Post: 06-12-2012, 01:40 PM
  3. how to dimension variables as %
    By napo537 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2010, 05:37 PM
  4. 3 dimension lookup problem
    By barkiny in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2006, 11:05 AM
  5. Matrix Dimension
    By Michelle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2005, 01:50 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