+ Reply to Thread
Results 1 to 4 of 4

Llookup the 3 values to get 1 value ( with specific range criteria )

Hybrid View

  1. #1
    Registered User
    Join Date
    06-15-2013
    Location
    India, Hyd
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Llookup the 3 values to get 1 value ( with specific range criteria )

    I am looking for an excel formula to get the result. Data is provided in below table

    There are 3 criteria based on which a single value needs to pick automatically.

    criteria 1 = value 1 variable
    criteria 2 = value 2 variable
    criteria 3 = value 3 variable

    I need a formula which will give me answer by considering all three criteria

    I have attached the excel sheet with sample data for better understanding of my problem

    Your expert help is really helpful. I have tried the fusion of lookup with index function but i haven't got the desired result.
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Llookup the 3 values to get 1 value ( with specific range criteria )

    where does 88.50%
    fit?
    do not use merged cells
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-15-2013
    Location
    India, Hyd
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Llookup the 3 values to get 1 value ( with specific range criteria )

    Quote Originally Posted by martindwilson View Post
    where does 88.50%
    fit?
    do not use merged cells


    Hello Sir

    88.50% fit in criteria A (90 to 85.1 )

    criteria A contains 4 conditions as below

    95.01% and above
    95% to 90.01%
    90 to 85.01%
    85% and below

    criteria B values are based on criteria A
    e.g. for criteria A if condition ( 95.01% and above ) meets then criteria B will be searched in 2 conditions 35 and 30
    when any one condition is matched in criteria B it should look for criteria C

    criteria C contains ony 2 conditions ( 25.1 to 30 Years and 25 Years or less )

    as per the above 3 criteria final answer should come automatically

    I hope you have understood my problem

    Regards

    Amar

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Llookup the 3 values to get 1 value ( with specific range criteria )

    Don't use merged cells, you get in trouble with it sooner or later.

    In this case it's sooner.

    Maybe with an pivot table.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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