Logic Problem With 4 Variables

[bdbrew]

Hello,
I need a formula to compare a single value to 4 variables and return TRUE or FALSE. In the table below, the answer should be TRUE when the Pick value matches the Color or the Shape AND the matching Color or Shape has the higher % (within the row). If the Pick value matches the lower %, then return FALSE.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Color[/TD]
[TD="align: center"]Color%[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Shape[/TD]
[TD="align: center"]Shape%[/TD]
[TD="align: center"][/TD]
[TD="align: center"]PICK[/TD]
[TD="align: center"]RESULT[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Blue[/TD]
[TD]72[/TD]
[TD][/TD]
[TD]Square[/TD]
[TD]28[/TD]
[TD][/TD]
[TD]Blue[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Green[/TD]
[TD]14[/TD]
[TD][/TD]
[TD]Triangle[/TD]
[TD]86[/TD]
[TD][/TD]
[TD]Triangle[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Red[/TD]
[TD]40[/TD]
[TD][/TD]
[TD]Circle[/TD]
[TD]60[/TD]
[TD][/TD]
[TD]Red[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Yellow[/TD]
[TD]97[/TD]
[TD][/TD]
[TD]Rectangle[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]Rectangle[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much,
bd

 

[njimack]

=or(and(g2=a2,b2>e2),and(g2=d2,e2>b2))

 

[bdbrew]

Thanks Neil,
This formula works when the Pick matches the color and the % is higher for the color, however, it is returning FALSE when the Pick matches the Shape and the % is higher for the Shape. This should be TRUE in that circumstance. Any suggestions?

thanks,
bd

 

[bdbrew]

Sorry Neil, my bad. I needed to convert to actual column letters and missed one. It work great. Thanks!