Results 1 to 3 of 3

Index , match , table value look up,

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Johannesburg
    MS-Off Ver
    Excel 2007
    Posts
    10

    Index , match , table value look up,

    I have a Table Margin with intervals from F2:P2 ( 100, 200,300,400, up to 1200).
    A1 is the Criterias A2: A12 ( 1200, 100, 300, 700 )
    IF C2 is 0.50 which falls in the criteria of 1200 the point that should be from P3= 1

    IF C12 is 5 which falls in the criteria of 1000 the point whould allocated is O12=9

    I have tried the following formula but gives me #N/A

    =INDEX($F$2:$P$18,MATCH(A2,$E$3:$E$18,0),MATCH(C2,$F$2:$P$18,0)) = #N/A
    Attached Files Attached Files

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