top of page

How to use VLOOKUP

  • Writer: Quest Computer Skills
    Quest Computer Skills
  • Aug 8, 2018
  • 1 min read

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

 
 
 

Recent Posts

See All
Did you lose your password?

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...

 
 
 
What is an aptitude test?

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...

 
 
 

Comments


011 622 5158

©2021 by Quest Computer Skills Centre

bottom of page