+ Reply to Thread
Results 1 to 9 of 9

Multiple condition, muktiple result

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    478

    Multiple condition, muktiple result

    Hi,
    In the table Cell A3 to C17 are the conditions that I have and D4 to E17 are their expected results in each conditions.

    From A22 to C36 are the real things which will be in my report and I need the results in D22 to E36 as per the above conditions.
    Is there any simpler way to do this? I have thought about making a formula using IF and AND, which results in a very bug formula.

    and I tried to achieve this by using CONCATENATE, but was unsuccessful...

    Please helpSachin.xlsx
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,683

    Re: Multiple condition, muktiple result

    Please let us know the conditions and the related results without that it is very hard for us to understand the concept. Really confused about Result1 & Result2 and don't know based on how you are arriving those results


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    478

    Re: Multiple condition, muktiple result

    Sorry...
    When A4,B4 and C4 are exactly like that, Result1 should be Excellent and Result 2 should be Exceed Expectation.
    As I said, A4 to E17 is the reference table.

    the actual things/formula shhould be in D22 to E36 depending on A22 to C36 after referencing the A4 to E17 table

  4. #4
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,743

    Re: Multiple condition, muktiple result

    see the attached file
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    478

    Re: Multiple condition, muktiple result

    WOW... that is working perfectly...

    Thanks nflsales

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,683

    Re: Multiple condition, muktiple result

    In D23 Cell

    =IFERROR(LOOKUP(2,1/(($A$4:$A$17=$A23)*($B$4:$B$17=$B23)*($C$4:$C$17=IF(--$C23>3,"3-above",IF(--$C23>0,"1-2",--$C23)))),D$4:D$17),"")

    Drag it down and right...

  7. #7
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    478

    Re: Multiple condition, muktiple result

    Quote Originally Posted by :) Sixthsense :) View Post
    In D23 Cell

    =IFERROR(LOOKUP(2,1/(($A$4:$A$17=$A23)*($B$4:$B$17=$B23)*($C$4:$C$17=IF(--$C23>3,"3-above",IF(--$C23>0,"1-2",--$C23)))),D$4:D$17),"")

    Drag it down and right...
    That is not working in every condition... But I got the solution... thanks

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,683

    Re: Multiple condition, muktiple result

    Quote Originally Posted by akhileshgs View Post
    That is not working in every condition... But I got the solution... thanks
    Check it before giving such a wrong statement!

    Refer the attached file and let me know where it fails.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    478

    Re: Multiple condition, muktiple result

    Sorry... I was putting your formula in the sheet attached by nflsales..

    Really sorry for the inconvenience

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Unable to combine IF & VLOOKUP for multiple condition to produce Result
    By kelwin2504 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2013, 08:06 PM
  2. [SOLVED] Help for if condition formula result only either hit or miss from mulitple condition
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 07:29 AM
  3. Lock Muktiple Rows in Excel
    By GCDDS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-21-2010, 04:56 AM
  4. Lookup & Result on Condition
    By tek9step in forum Excel General
    Replies: 10
    Last Post: 06-26-2009, 08:43 PM
  5. [SOLVED] Formula for calculating Gross Profit with muktiple discounts
    By CARM in forum Excel General
    Replies: 2
    Last Post: 09-25-2005, 11:05 AM

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