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
Comentários