Formula to bring a value from another tab but ignore duplicates

[amasson]

Hi Folks,

I am confused with this one and really hoping that someone can help me.

Issue:
See attached file for example
1. I have some data in the "Report" tab and I want to populate column C based on what is in Column D.
2. Column C needs to look what is in Column D and then bring back the amount from the "Data" tab.
3. If the value in Column D is duplicated then ignore any further amounts. So for example, I would expect C6 to be 0.00

Is this possible?

Thank you,
Andrew