One way:

C1: =IF(A1=B1,D1,"")

In article ,
Ragnar wrote:

In excel If 2 columns have an equal value I want a 3rd column to display the
value from a 4th column, what is the syntax for this?