ASSIGNMENT – 17
Answer Key – HLOOKUP
Product Master Table
| 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 | |
|---|---|---|---|---|---|---|---|---|
| ID | 301 | 302 | 303 | 304 | 305 | 306 | 307 | 308 |
| Brand | Dell | HP | Lenovo | Samsung | Logitech | Canon | Acer | Asus |
| Product | Laptop | Printer | Computer | Monitor | Keyboard | Scanner | Mouse | Tablet |
| Price | ₹60,000 | ₹15,000 | ₹45,000 | ₹20,000 | ₹1,300 | ₹10,000 | ₹900 | ₹25,000 |
Q.1 Find the Product of ID 304
=HLOOKUP(304,B1:I4,3,FALSE)Answer: Monitor
Q.2 Find the Brand of ID 307
=HLOOKUP(307,B1:I4,2,FALSE)Answer: Acer
Q.3 Find the Price of ID 301
=HLOOKUP(301,B1:I4,4,FALSE)Answer: ₹60,000
Q.4 Find the Product and Brand of ID 305
Product
=HLOOKUP(305,B1:I4,3,FALSE)Answer: Keyboard
Brand
=HLOOKUP(305,B1:I4,2,FALSE)Answer: Logitech
Q.5 Find the Complete Details of ID 308
Product
=HLOOKUP(308,B1:I4,3,FALSE)Answer: Tablet
Brand
=HLOOKUP(308,B1:I4,2,FALSE)Answer: Asus
Price
=HLOOKUP(308,B1:I4,4,FALSE)Answer: ₹25,000
Q.6 Find the Price of ID 302
=HLOOKUP(302,B1:I4,4,FALSE)Answer: ₹15,000
Q.7 Find the Brand and Product of ID 306
Brand
=HLOOKUP(306,B1:I4,2,FALSE)Answer: Canon
Product
=HLOOKUP(306,B1:I4,3,FALSE)Answer: Scanner
Q.8 Find the Complete Details of ID 303
Brand
=HLOOKUP(303,B1:I4,2,FALSE)Answer: Lenovo
Product
=HLOOKUP(303,B1:I4,3,FALSE)Answer: Computer
Price
=HLOOKUP(303,B1:I4,4,FALSE)Answer: ₹45,000
Q.9 Find the Product, Brand and Price of ID 307
Product
=HLOOKUP(307,B1:I4,3,FALSE)Answer: Mouse
Brand
=HLOOKUP(307,B1:I4,2,FALSE)Answer: Acer
Price
=HLOOKUP(307,B1:I4,4,FALSE)Answer: ₹900
Q.10 Find the Complete Details of ID 301
Product
=HLOOKUP(301,B1:I4,3,FALSE)Answer: Laptop
Brand
=HLOOKUP(301,B1:I4,2,FALSE)Answer: Dell
Price
=HLOOKUP(301,B1:I4,4,FALSE)Answer: ₹60,000
Completed Search Table
| ID | Product | Brand | Price |
|---|---|---|---|
| 304 | Monitor | Samsung | ₹20,000 |
| 307 | Mouse | Acer | ₹900 |
| 301 | Laptop | Dell | ₹60,000 |
| 305 | Keyboard | Logitech | ₹1,300 |
| 308 | Tablet | Asus | ₹25,000 |
| 302 | Printer | HP | ₹15,000 |
| 306 | Scanner | Canon | ₹10,000 |
| 303 | Computer | Lenovo | ₹45,000 |
| 307 | Mouse | Acer | ₹900 |
| 301 | Laptop | Dell | ₹60,000 |
Final Answer Summary
| Q. No. | Answer |
|---|---|
| Q1 | ID 304 → Monitor |
| Q2 | ID 307 → Acer |
| Q3 | ID 301 → ₹60,000 |
| Q4 | ID 305 → Keyboard, Logitech |
| Q5 | ID 308 → Tablet, Asus, ₹25,000 |
| Q6 | ID 302 → ₹15,000 |
| Q7 | ID 306 → Canon, Scanner |
| Q8 | ID 303 → Lenovo, Computer, ₹45,000 |
| Q9 | ID 307 → Mouse, Acer, ₹900 |
| Q10 | ID 301 → Laptop, Dell, ₹60,000 |
Remember
HLOOKUP searches horizontally.
=HLOOKUP(lookup_value,table_array,row_index_num,FALSE)-
2→ Brand -
3→ Product -
4→ Price
The lookup value (ID) must be in the first row of the selected table.