Vlook up compare two columns and more!

Hello!

I urgently need to do the following....

I have a column of numbers (A) a column of names (B) A column of Durations (C) a larger column of Numbers (D) then a column that the VLOOK up pulls to E.

1) I have two rows of numbers. I have to see if one set the numbers in the first list (A) feature in the list (D) some may be present multiple times but need to be flagged individually in Column E.

2) Lastly When the data in column D is present in column A I need to pull the corresponding duration from column C through to the cell next to the production that has been flagged (F).

Any help would be great I'm really struggling. I've used the following formula and managed to identify which numbers are in each both columns =VLOOKUP(D373,$A$2:$A$10000,1,FALSE) but I don't know how to then drag the duration into the cell next doOR so I can count up the hours.

If anyone knows an easier way to do this please let me know. I'm not that experienced with excel so step by step would be great!

Thanks for your help