=if(or(a4=b3,a4=e4),result1, result2)

Change result1 & result2 to your needs

"Nicola H." wrote:

How do I make a cell's value contingent upon what is in two other
cells. For example A4 is equal to b3 or e4 depending on their value.