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.

PreviousNext