• Quest Computer Skills

How to use VLOOKUP

Type the following in Excel:

CODE DESCRIP PRICE

102 Milk 22.36

103 Eggs 25.88

104 Flour 33.92

105 Sugar 38.22

106 Biscuits 22.33


· Create a new file in Excel, and type the following:

Code Description


· Click in cell B2 where information is required eg. Description

· Click on Insert function

In the Insert Function Window

· Click on VLOOKUP

· Click on OK


In VLOOKUP window

1. Type A2 in Lookup_value

2. Click in Table_array

3. Click on Red Arrow at right side

4. Click on file Your name Jack’s Price List in Taskbar to open it

5. Select A1:C20 (to allow for more entries), ENTER or x

6. Click in Col_index_num

7. Type: 2 (column no. where match is to be found)

8. Click in Range_lookup

9. Type false for exact match

10. Click on OK

11. Drag formula down using fill handle

48 views0 comments

Recent Posts

See All

JOB TIPS >> How to reset your password on INTERNET JOB SITES: 1) Open the job site 2) Click on log in 3) Type in your e-mail address 4) Then it will allow you to type in your password 5) Click on for

ABOUT JOBS What is an aptitude test? A lot of companies ask candidates to write an aptitude test, when they are applying for a new position. The test lasts from 10 minutes to an hour. The company is t