ASSIGNMENT – 16
Answer Key – VLOOKUP
Product Master Table
| ID | Brand | Product | Price |
|---|---|---|---|
| 201 | Dell | Laptop | ₹55,000 |
| 202 | Logitech | Keyboard | ₹1,200 |
| 203 | HP | Printer | ₹14,500 |
| 204 | Samsung | Monitor | ₹18,000 |
| 205 | Lenovo | Computer | ₹42,000 |
| 206 | Canon | Scanner | ₹9,500 |
| 207 | Acer | Laptop | ₹48,000 |
| 208 | Logitech | Mouse | ₹850 |
| 209 | HP | Keyboard | ₹1,500 |
| 210 | Dell | Monitor | ₹16,500 |
Q.1 Find the Brand of ID 204
=VLOOKUP(204,A2:D11,2,FALSE)Answer: Samsung
Q.2 Find the Product and Price of ID 207
Product
=VLOOKUP(207,A2:D11,3,FALSE)Answer: Laptop
Price
=VLOOKUP(207,A2:D11,4,FALSE)Answer: ₹48,000
Q.3 Find the Brand and Product of ID 201
Brand
=VLOOKUP(201,A2:D11,2,FALSE)Answer: Dell
Product
=VLOOKUP(201,A2:D11,3,FALSE)Answer: Laptop
Q.4 Find the Price of ID 209
=VLOOKUP(209,A2:D11,4,FALSE)Answer: ₹1,500
Q.5 Find the Brand, Product and Price of ID 205
Brand
=VLOOKUP(205,A2:D11,2,FALSE)Answer: Lenovo
Product
=VLOOKUP(205,A2:D11,3,FALSE)Answer: Computer
Price
=VLOOKUP(205,A2:D11,4,FALSE)Answer: ₹42,000
Q.6 Find the Product of ID 210
=VLOOKUP(210,A2:D11,3,FALSE)Answer: Monitor
Q.7 Find the Price of ID 203
=VLOOKUP(203,A2:D11,4,FALSE)Answer: ₹14,500
Q.8 Find the Brand and Price of ID 208
Brand
=VLOOKUP(208,A2:D11,2,FALSE)Answer: Logitech
Price
=VLOOKUP(208,A2:D11,4,FALSE)Answer: ₹850
Q.9 Find the Complete Details of ID 206
Brand
=VLOOKUP(206,A2:D11,2,FALSE)Answer: Canon
Product
=VLOOKUP(206,A2:D11,3,FALSE)Answer: Scanner
Price
=VLOOKUP(206,A2:D11,4,FALSE)Answer: ₹9,500
Q.10 Find the Complete Details of ID 202
Brand
=VLOOKUP(202,A2:D11,2,FALSE)Answer: Logitech
Product
=VLOOKUP(202,A2:D11,3,FALSE)Answer: Keyboard
Price
=VLOOKUP(202,A2:D11,4,FALSE)Answer: ₹1,200
Completed Search Table
| ID | Brand | Product | Price |
|---|---|---|---|
| 204 | Samsung | Monitor | ₹18,000 |
| 207 | Acer | Laptop | ₹48,000 |
| 201 | Dell | Laptop | ₹55,000 |
| 209 | HP | Keyboard | ₹1,500 |
| 205 | Lenovo | Computer | ₹42,000 |
| 210 | Dell | Monitor | ₹16,500 |
| 203 | HP | Printer | ₹14,500 |
| 208 | Logitech | Mouse | ₹850 |
| 206 | Canon | Scanner | ₹9,500 |
| 202 | Logitech | Keyboard | ₹1,200 |
Final Answer Summary
| Q. No. | Answer |
|---|---|
| Q1 | ID 204 → Samsung |
| Q2 | ID 207 → Laptop, ₹48,000 |
| Q3 | ID 201 → Dell, Laptop |
| Q4 | ID 209 → ₹1,500 |
| Q5 | ID 205 → Lenovo, Computer, ₹42,000 |
| Q6 | ID 210 → Monitor |
| Q7 | ID |