Newbie Q-Formular for this situation...????

[Astroboy]

Hello all...


If...

B2=A
C2=B
D2=C

Then on G5 show "YES"


If...

B2=B
C2=C
D2=A

Then on G5 show "NO"

....

B2,C2,D2 can have one of the A,B,C and base on that G5 showing the word...


Any help will be great... and thank you...

 

[Sheeloo]

=IF(AND(B2="A",C2="B",D2="C"),"Yes",IF(AND(B2="B",C2="B",D2="C"),"No","Neither"))

It will return 'Neither' if both conditions are not met.

 

[Max]

Another play ..
In G5: =VLOOKUP(B2&C2&D2,{"ABC","Yes";"BCA","No"},2,0)
Expand the table array to suit other combos & returns
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik