Comparision of Data (IF)

Hello:

I need to pull the following data from attached above. I need the following assistance:

Note there are 2 tabs(Legacy and NEW).

Column A in the NEW tab has the finished good number. Column C has the components tied to the finished good number. I need to validate if those Components in column C are also in the "LEGACY" tab. I'd like to add this in Column D.

In Column E i'd like to identify the number of components that are in the LEGACY tab for the corresponding finished good in Column A.

If the component is tied to the finished good I'd like to add the percentage from the LEGACY tab in column G.

Thanks for the support.