Hi,
In A4 enter

=if(A2=Sheet2!D6,D10,"")

I assume that if the result doesn't match you want blank in that cell

If this helps please click yes, thanks

"conditional format if cell contains word" wrote:

IF A CELL ON ONE WORK SHEET MATCHES ANOTHER WORKSHEET

for instance if A2 on worksheet one = D6 on Worksheet 2 then I want A4 on
worksheet one to equal D10