Is it possible to do this?

[Guest]

Im looking for a function (hopefully) that allows me to do something like this:

IF C2=Sheet!B2 then "write"Sheet!D2 ElseIF "Blank"

* Also when I specity C2 (for example) I actually need it for the whole C
(column), so I would need to copy it, right?

*or instead of blank, fill the cell with yellow or red.

Is this possible?

Ivan

 

[Guest]

Try this and drag down as required:-

=IF(C2=Sheet2!B2,Sheet2!D2,"")

Mike