Project 1 — Employee Database

Create an employee database containing:

Employee ID | Name | Department | Designation | Salary | Joining Date

Create a lookup box where the user enters Employee ID and automatically retrieves:

• Employee Name
• Department
• Designation
• Salary
• Joining Date

Use:

XLOOKUP / VLOOKUP / INDEX + MATCH

Project 2 — Product Price Lookup

Create:

Product ID	Product	Category	Price
P101	Keyboard	Accessories	800
P102	Mouse	Accessories	500
P103	Monitor	Hardware	8500
P104	Printer	Hardware	12000

Enter a Product ID and retrieve:

• Product Name
• Category
• Price

Project 3 — Student Result Lookup

Create:

Roll No. | Student Name | English | Maths | Computer | Total | Percentage | Grade

Enter Roll No. and retrieve the student’s:

• Name
• Marks
• Total
• Percentage
• Grade

Use XLOOKUP or INDEX + MATCH.

Project 4 — Inventory Lookup

Create:

Product ID | Product | Category | Stock | Price | Supplier

Build a lookup system that retrieves complete product information from Product ID.

Also display:

• Out of Stock
• Low Stock
• Available

using lookup + logical functions.

Project 5 — Sales Commission Calculator

Create:

Employee	Sales	Commission Rate
Amit	50000	5%
Neha	80000	7%
Rahul	120000	10%

Use lookup functions to retrieve the applicable commission rate.

Then calculate:

=Sales*Commission_Rate

Create a final Sales Commission Report.