Project: Employee & Product Lookup System

Create a workbook containing two lookup systems.

Part A — Employee Master

Employee ID	Employee	Department	Salary	Location
E101	Amit	Sales	35000	Sirsa
E102	Neha	HR	42000	Hisar
E103	Rahul	IT	55000	Sirsa
E104	Priya	Finance	48000	Fatehabad
E105	Simran	Sales	39000	Hisar

Create a search box where the user enters an Employee ID.

Automatically return:

• Employee Name
• Department
• Salary
• Location

Use XLOOKUP.

Example:

=XLOOKUP(H2,A2:A6,B2:B6,”Not Found”)

Part B — Product Master

Product ID	Product	Category	Price	Stock
P101	Keyboard	Accessories	800	50
P102	Mouse	Accessories	500	75
P103	Monitor	Hardware	8500	20
P104	Printer	Hardware	12000	15
P105	Webcam	Accessories	2500	30

Use:

• VLOOKUP
• XLOOKUP
• INDEX + MATCH

to retrieve product information.

Final Challenge

Create an Interactive Lookup Dashboard containing:

• Employee ID search
• Employee details
• Product ID search
• Product details
• Salary/price information
• Department/category
• Location/stock
• “Not Found” handling

The final worksheet should look like a simple professional search system rather than a normal data table.