If statement bringing back 2 true values

[Imran Azam]

Hi ,

I have the look up table below

A	B	C	D	E	STATUS
YES	YES				GOOD
		NO	NO	FAST	BAD

<tbody>
</tbody>

<tbody>
</tbody>

i have a table of data below and i need to pick the correct status based on the rules in the look up table.

name	A	B	C	D	E	STATUS
craig	yes	yes	no	no	fast	GOOD

<tbody>
</tbody>

now i used the following statement to pick the status ( good) up IF(AND($A$2=B8,$B$2=C8),$F$2,IF(AND($C$3=D8,$D$3=E8,$E$3=F8),$F$3,""))

i want to know how i can pull back tWo true value because, the above data matches both the good and bad status rule , is this possible? IT SHOULD looks like the below

name	A	B	C	D	E	STATUS	status2
craig	yes	yes	no	no	fast	GOOD	BAD

<tbody>
</tbody>

 

[mcmuney]

Re: help needed if statement bringing back 2 true values

All you have to do is split up your formula and place the first IF(AND statement in columnSTATUS and the second IF(AND statement in columnSTATUS2.

 

[Imran Azam]

Re: help needed if statement bringing back 2 true values

thank you , but how will that work will they both bring back different status?

 

[mcmuney]

Re: help needed if statement bringing back 2 true values

thank you , but how will that work will they both bring back different status?

Since it will be blank if there's no match, these will be your possibilities:

STATUS	STATUS2
GOOD	BAD
GOOD	""
""	BAD
""	""

<tbody>
</tbody>

How you use this data will depend on how you'll utilize the results.

 

[Imran Azam]

Re: help needed if statement bringing back 2 true values

AH ok thanks but i need the formula to be able to fill the first status and if its matches a second status only then use the status 2 , dont know if this can be done, thank you for your help