Array formula only working on first reference

[gwynwjones]

Hi,

I have this array formula but it's only working when it finds Gold, when Silver is in D2, it still returns the value in A2

=IF(D2={"Gold","Silver","Bronze"},E2,A2)

 

[gwynwjones]

And I am doing Control Shift Return!

 

[Peter_SSs]

Perhaps you mean
=IF(OR(D2={"Gold","Silver","Bronze"}),E2,A2)
(which doesn't require C+S+E)

 

[gwynwjones]

Great, thank you

 

[Peter_SSs]

Great, thank you

You're welcome.