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.

	A	B	C	D	E	F	G	H
1	Color	Color%		Shape	Shape%		PICK	RESULT
2	Blue	72		Square	28		Blue	TRUE
3	Green	14		Triangle	86		Triangle	TRUE
4	Red	40		Circle	60		Red	FALSE
5	Yellow	97		Rectangle	3		Rectangle	FALSE

<tbody>
</tbody>

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!