Results 1 to 3 of 3

Thread: Index and Match

  1. #1
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Index and Match

    Hi All,

    I am using and Index and Match formula to do a conditional lookup. However, something is going wrong can you look at the formula and let me know where the problem is. Attached the file for your reference.

    Thanks
    Nethra
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Goulburn. NSW, Australia
    Posts
    20
    Thanks
    3
    Thanked 4 Times in 4 Posts
    Try changing the formula in C2 to be =OFFSET(Sheet2!$F$3,MATCH(A2,Sheet2!$F$3:$F$6),MAT CH(B2,Sheet2!$G$2:$L$2))

    Then copy it down.

  3. #3
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    Tried using the formula but is not working :-(

    Regards
    Nethra

Posting Permissions

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