1) Are you looking for Formula solution or Macro Code solution.
The esiest and quickest one! I hope that answer is enough!

2) How the values are arrived in sheet3? based on single asterisk in Column-F of sheet2
I dont quite under stand your question. But I hope this will help you:

Sheet 2 is a list which contains all of my companys products

Sheet 3 is a list of Art nr I get from Marketing. This is a set of products they want in a new campaign. My job is to supplement these Art nr with the data from sheet 2. I got booth sheet 2 and the in simple .xlsx.

Hope this is enough!?