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.

 

[Aladin Akyurek]

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

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.[/QUOTE]

Try...

=IFERROR(VLOOKUP(U8&Y8&Z8,{"145",1;"146",1;"036",2;"046",2;"236",3;"245",4},2,0),0)

 

[hsandeep]

Yes it WORKS

 

[Aladin Akyurek]

Yes it WORKS

Great. Thanks for providing feedback.