Formula:
=IF('Joining Award Done'!D7=Tenderheart),='Joining Award Done'!D19,"•"
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
Formula:
=IF('Joining Award Done'!D7='Summary Page'!C2),='Joining Award Done'!D19,"•"
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
Formula:
=IF('Joining Award Done'!D7='Summary Page'!C2:D2),='Joining Award Done'!D19,"•"
and after clicking ok in the error message, D2 is highlighted.
Please show me my error. Thanks.
Bookmarks