Results 1 to 6 of 6

HOW TO ? - Having issue with INDEX / Match and to nest with IF

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    40

    HOW TO ? - Having issue with INDEX / Match and to nest with IF

    Pls. correct / suggest way to combine the following and to get desired result, currently its showing me error #N/A

    =IF(D28="FE",(INDEX(FEDEX_DOM_PRICE!B228:K302,MATCH(G28,FEDEX_DOM_PRICE!A228:A302,-1),(MATCH(B28,FEDEX_DOM_PRICE!B227:K227,0)))),("none"))

    =IF(D28="FSO",(INDEX(FEDEX_DOM_PRICE!B151:N225,MATCH(G28,FEDEX_DOM_PRICE!A151:A225,-1),(MATCH(B28,FEDEX_DOM_PRICE!B150:N150,0)))),("none"))

    =IF(D28="FPO",(INDEX(FEDEX_DOM_PRICE!B3:N148,MATCH(G28,FEDEX_DOM_PRICE!A3:A148,-1),(MATCH(B28,FEDEX_DOM_PRICE!B2:N2,0)))),("none"))


    The above are the condition checks required for Freight.
    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. Index-Match Issue (I Think)
    By rormis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2012, 05:43 AM
  2. [SOLVED] index match issue
    By jw01 in forum Excel General
    Replies: 3
    Last Post: 07-19-2012, 12:31 AM
  3. index match issue
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 07-13-2012, 11:02 PM
  4. index match (issue)
    By step_one in forum Excel General
    Replies: 5
    Last Post: 05-16-2011, 02:58 PM
  5. index..match - issue
    By step_one in forum Excel General
    Replies: 15
    Last Post: 05-03-2011, 08:25 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