Need Help with Excel 2003 Formula for My Project – Can You Assist?

Dear Sir/Madam Experts, Please take a look at my Excel file, which I have attached on this site. I would like to request your assistance in finding a solution for my query. I have indicated in the boxes, and I need the formula for that. This is a requirement for my project at the moment. I am looking forward to hearing from any of the experts. Thank you so much.

Regards,
D.S. Prakash
(From Qatar)

Add a Combo Box for SYSTEM NUMBER

Assign a Macro to the Combo. The Macro Should:
- Filter Sheet 2 as per the Combo selection.
- Then copy the filtered list to Sheet 3.
- Use VLOOKUP to populate the required cells in Sheet 1.
- Clear Sheet 3.

Regards,
Saivettam Consultants

[The link provided no longer exists.]