+ Reply to Thread
Results 1 to 4 of 4

Nested If...then To Lookup Value Based on Two Ranges

  1. #1
    Registered User
    Join Date
    01-18-2008
    Posts
    3

    Nested If...then To Lookup Value Based on Two Ranges

    Hi - I'm a new member to this forum. I'm trying to come up with a UDF that will take two inputs representing four ranges each and look up the intersecting value. Specifically, I have four sets of probabilities and four sets of severities (impacts), and for each combination there is a defined Action. Picture a matrix with the 4 probability ranges on the Y Axis and the 4 Impact ranges on the X axis. I think I'm close but I just cannot get this function to work. Any help is much appreciated.

    Here's the matrix and the code I have so far:

    >70% Action 1 Action 3 Action 4 Action 4
    >40 to <70% Action 1 Action 2 Action 3 Action 4
    >10 to <40% Action 1 Action 2 Action 3 Action 3
    0 to <10% Action 1 Action 1 Action 2 Action 2
    0 to ≤7 >7 to ≤14 >14 to ≤24 >24



    Please Login or Register  to view this content.
    Last edited by NBVC; 01-18-2008 at 01:47 PM.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Please read forum rules and message to cross posters below then add the link to the cross post

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    01-18-2008
    Posts
    3
    Quote Originally Posted by VBA Noob
    Please read forum rules and message to cross posters below then add the link to the cross post

    VBA Noob
    Sorry for cross-posting this question - here is the URL for my other post http://www.mrexcel.com/forum/showthread.php?t=298679

    I'll be sure not to post this anywhere else - and will update both sites if/once problem has been solved. I appreciate any help.

  4. #4
    Registered User
    Join Date
    01-18-2008
    Posts
    3
    Quote Originally Posted by VBA Noob
    ...then add the link to the cross post

    VBA Noob
    Question solved - see cross post. Thanks for politely explaining how this all works. I look forward to helping out here where I can.

+ 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