ASSIGNMENT – 16

Use of Formula – 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

Search Table

Use VLOOKUP to fill in the blank columns.

ID	BRAND	PRODUCT	PRICE
204
207
201
209
205
210
203
208
206
202

Questions

Q.1

Using VLOOKUP, find the Brand of ID 204.

Q.2

Find the Product and Price of ID 207.

Q.3

Find the Brand and Product of ID 201.

Q.4

Find the Price of ID 209.

Q.5

Find the Brand, Product and Price of ID 205.

Q.6

Find the Product of ID 210.

Q.7

Find the Price of ID 203.

Q.8

Find the Brand and Price of ID 208.

Q.9

Find the complete details of ID 206.

Find:

• Brand

• Product

• Price

Q.10

Find the complete details of ID 202 using VLOOKUP.

Find:

• Brand

• Product

• Price

VLOOKUP Syntax

=VLOOKUP(lookup_value,table_array,column_number,FALSE)

Example

To find the Brand of ID 204:

=VLOOKUP(204,A2:D11,2,FALSE)

To find the Product:

=VLOOKUP(204,A2:D11,3,FALSE)

To find the Price:

=VLOOKUP(204,A2:D11,4,FALSE)

Column Numbers

Column	Field	VLOOKUP Column Number
A	ID	1
B	Brand	2
C	Product	3
D	Price	4

Note: Use FALSE for an exact match because we want the exact details of each Product ID.