Can't get if formula to work

[swmwshrk]

Please Login or Register  to view this content.

I want to copy the data from the joining award page cell d19 to the summary page cell c4 IF Joining award page cell d7 has the word tenderheart in it. IF Joining award page d7 contains anything else, I just want the bullet point. AFAIK the formula above should work but excel keeps telling me there is an error. When I click okay, Excel highlights Tenderheart in the formula bar.

I then tried

Please Login or Register  to view this content.

where summary page d2=Tenderheart, and still get the error message, and after I click ok, Excel highlights C2.

I figured this might be because C2 & D2 are merged so I tried

Please Login or Register  to view this content.

and after clicking ok in the error message, D2 is highlighted.

Please show me my error. Thanks.

[Søren Larsen]

Try this instead:

Please Login or Register  to view this content.

[swmwshrk]

Perfect. thank you so much. Both for the answer and the speed.

[Pepe Le Mokko]

A bit shorter

Please Login or Register  to view this content.

[swmwshrk]

Thanks for the alternate suggestion.