Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Index & Match ? (Excel 2002/2003)

    Hi

    I am having a problem with Index & Match, please see attached.

    Thanks in advance

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Index & Match ? (Excel 2002/2003)

    Use this array formula:

    =INDEX(E2:E9,MATCH(A19&B19,A2:A9&C2:C9,0))
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Index & Match ? (Excel 2002/2003)

    Hi Jan Karel

    Thanks for the prompt reply, I tried your formula and I get #Value!

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Index & Match ? (Excel 2002/2003)

    Hi Jan Karel

    I forgot to enter as an array. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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