Results 1 to 3 of 3

Thread: INDEX - MATCH

  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I am enclosing a workbook that I am developing a "INDEX-MATCH" Formula for. I cannot figure out why I keep getting a "REF#" for the value? Any insights?
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Your Index formula evaluates to:
    =INDEX('WIDGETS BY PURCHASER NOV_2009'!$A$9:$AO$9,5,6)

    You are specifying a 1 row by 41 column array but are asking the formul to returen the result in the 5th row. Change your formula to include all of the rows.
    Code:
    =INDEX('WIDGETS BY PURCHASER NOV_2009'!$A$9:$AO$16,MATCH(+$H$6,'WIDGETS BY PURCHASER NOV_2009'!$A$5:$A$15,0),MATCH(SUMMARY!A19,'WIDGETS BY PURCHASER NOV_2009'!$A$2:$AO$2,0))
    You do not need to confirm the formula as an array formula using Ctrl+Shift+Enter.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    That's the ticket.

    Thanks.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •