1 value to be picked out of 3 cells

[hsandeep]

3 cells generates 1 or 0; 3 or 4; 5 or 6.
Answer required in 4th cell based on the 3 cell values ...please bear with me.

Ex:
U8=1/0 ; Y8=3/4; Z8=5/6
Answer (in cell AA8)= 1 (if U8 has generated 1)
AA8=0 (if U8 has generated 0)
AA8=3 (if Y8 has generated 3)
AA8=4 (if Y8 has generated 4)
AA8=5 (if Z8 has generated 5)
AA8=6 (if Z8 has generated 6)

What formula needs to be filled in AA8?
Thanx in adv.

 

[bbott]

I assume that sometimes U8 is blank...otherwise your answer will always be 0 or 1. But try this:

=IF(U8=1,1,MIN(U8,Y8,Z8))

 

[Andrew Poulsom]

I don't see how what's in Y8 can ever be returned, but maybe:

=IF(U8=0,U8,MAX(U8,Y8:Z8))

 

[bbott]

And looking at both Andrew's and my formulas, I think we would need to know the order of precedence.

 

[hsandeep]

Yes I will make it VERY CLEAR.
U8=1/0/2 ; Y8=3/4; Z8=5/6

AA8=1 if U8 Y8 Z8 generates 1 4 5 respectively
AA8=2 if U8 Y8 Z8 generates 0 3 6 respectively
AA8=3 if U8 Y8 Z8 generates 2 3 6 respectively
AA8=4 if U8 Y8 Z8 generates 2 4 5 respectively

I hope i have tried to clear... Formula needed in AA8?

 

[Aladin Akyurek]

Yes I will make it VERY CLEAR.
U8=1/0/2 ; Y8=3/4; Z8=5/6

AA8=1 if U8 Y8 Z8 generates 1 4 5 respectively
AA8=2 if U8 Y8 Z8 generates 0 3 6 respectively
AA8=3 if U8 Y8 Z8 generates 2 3 6 respectively
AA8=4 if U8 Y8 Z8 generates 2 4 5 respectively

I hope i have tried to clear... Formula needed in AA8?

Try:

=MATCH(U8&Y8&Z8,{"145","036","236","245"},0)

 

[hsandeep]

Try:

=MATCH(U8&Y8&Z8,{"145","036","236","245"},0)

Can the answer come #N/A? I think for no match answer should come 0 (as present in the formula). But for a combination generated 2 4 6 answer is coming #N/A. I need 0 then in such cases of no match.

 

[bbott]

Can the answer come #N/A? I think for no match answer should come 0 (as present in the formula). But for a combination generated 2 4 6 answer is coming #N/A. I need 0 then in such cases of no match.

To ammend Aladin's formula for a non-match:

=IFERROR(MATCH(U8&Y8&Z8,{"145","036","236","245"},0),0)

 

[hsandeep]

it WORKS.

 

[hsandeep]

=IFERROR(MATCH(U8&Y8&Z8,{"145","036","236","245"},0),0)[/QUOTE]

Can I also get answer=1 for U8 V8 Z8 being 146
Can I also get answer=2 for U8 V8 Z8 being 046. This is in addition to above.