+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : how to fix if,index, match

Hybrid View

lizsantiago07 how to fix if,index, match 06-18-2012, 11:02 PM
RobertMika Re: how to fix if,index, match 06-18-2012, 11:52 PM
lizsantiago07 Re: how to fix if,index, match 06-19-2012, 12:30 AM
lizsantiago07 Re: how to fix if,index, match 06-19-2012, 07:56 PM
  1. #1
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    how to fix if,index, match

    I have this formula: =IF(N1SR!H12=ESTSR!$G$9,INDEX(N1SR!H$14:H$48,MATCH($D$9,N1SR!$G$14:$G$48,0),MATCH($G$9,N1SR!$H$12:$H$12,0)),"")

    it works perfectly and it returns the values of h14:h48 which is what i need, but now i need the same thing but instead of returning h14:h48 i need to return only the value in h4 but no matter what i change in the formula it doesnt seem to work. can someone help me?

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: how to fix if,index, match

    Could you post your sheet and enter desired result?

  3. #3
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: how to fix if,index, match

    Sure thks. I EXPLAINED what i need in the worksheet
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: how to fix if,index, match

    Any help please i have tried everything!!

+ 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