+ Reply to Thread
Results 1 to 3 of 3

Index/Match Question

  1. #1
    Registered User
    Join Date
    01-29-2009
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    43

    Index/Match Question

    I'm having a bit of a block with an index/match formula that I am trying to create for the attached spreadsheet. i.e. I need to populate cell J3 with the info the corresponding letter contained in the table to the far left. The numbers of reference to match are the 'zones' in H3 and J2.
    Attached Files Attached Files
    Last edited by mikera; 01-07-2010 at 07:02 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Index/Match Question

    Hi,

    you just need INDEX, not MATCH, because your index positions are given in col H and row 2, so

    =INDEX($B$2:$E$9,$H3,J$2)

    copied down and across.
    the only row that bombs is row 22, because of the 14, and your lookup table only has 8 rows
    Last edited by teylyn; 01-07-2010 at 07:23 PM.

  3. #3
    Registered User
    Join Date
    01-29-2009
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    43

    Re: Index/Match Question

    Thanks a ton

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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