Results 1 to 25 of 25

help with a INDEX and MATCH formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    London, England
    MS-Off Ver
    Excel 2011
    Posts
    474

    help with a INDEX and MATCH formula

    i have an empty column which i want to be filled in based on the header and sub header of another column.
    I want cell R18 to be matched with row 1 AND cell R22 to be matched with row 2.
    so the formula in column N can pinpoint exactly which column i want copied over.

    this is the formula i currently have but im getting the VALUE! error in the cell
    Formula: copy to clipboard
    =INDEX($B3:$M3,1,MATCH($R$18,$B$1:$M$1,0)+$R$22,$B$2:$M$2)


    please 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. help with index/match or vlookup/match formula
    By tsiguy96 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2013, 07:57 PM
  2. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  3. Index Match Index Formula work slow
    By avk in forum Excel General
    Replies: 9
    Last Post: 03-07-2012, 02:19 PM
  4. Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  5. Nested Match(index()) vs. Match() array formula.
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2011, 07:57 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