# Multiple condition, muktiple result

1. ## 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...

2. ## 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

3. ## 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. ## Re: Multiple condition, muktiple result

see the attached file

5. ## Re: Multiple condition, muktiple result

WOW... that is working perfectly...

Thanks nflsales

6. ## 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. ## Re: Multiple condition, muktiple result

Originally Posted by :) Sixthsense :)
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. ## Re: Multiple condition, muktiple result

Originally Posted by akhileshgs
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.

9. ## Re: Multiple condition, muktiple result

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

Really sorry for the inconvenience

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