Download Excel Cheat Sheet VLookUp and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity! By Excel Cheat She
Ast Argument: 83 - Lookup_Value.
VLOOKUPS
VLOOKUP(B3,C1:F6,4,0)
et
The ‘v' in VLOOKUP stands for Vertical - this tells Excel what direction to look in the first column of your Table
This is the value what you want Excel to find - must be contained within the first column in the Table Array
‘F6-Table_Array This is the data (table) you select that you want Excel to look in- Must begin with the Lookup Volue
rd Argument: 4 - Col_Index_Num
4th Argument:
0 (or False) - Range_Lookup
“When you select the Table Array, Excel indexes the columns in numbers, the column number you place in the
formula will determine the information Excel retrieves back far you
This determines what type of match you get; True - Approximate Match; False - Exact Match
f left blank it will default to True. Alternatively you can use the numbers 1 for True and 0 for False
VLaokUp Funetion Salations (See formulas on the ather side of this sheet) |
e I C One| E F
N Retail Price |
1| This forraula is looking up the Item ‘tam Number Description Invoie
2. Number and retrieving the information 1120 Knives €26.00)
3 ii 2010 Side Plates €46,50
4 lookupValue ItemNumber 2010 3040 Dinner Plales €68.50.
5 . invoica Number 1230 3049 Dishwasher €350.00
Infarmation on ra .
6 Description Side Plates 3145 Cloihs e775
Item Number - — at
7 Retail Price (£46.50 3292 Strainer €12.78
VLookUp Function Formulas (See Solution {Answers} on the other side of this sheet)
Column Index Number 1 2 3 a
=a eee [ee ee | ea ee eee ce :
1 Item Number Description Invoice Number
2 Note: 1120 Knives 1167 €25.00)
3 Commas are 2010 Side Plates 1230 €46 50
4 usedto separate Item Number 2010 3040 Dinner Plates 1011 €68.50)
S each argument Invoica Number — =VLOOKUP(B4,C2:F7,3,0) 3049 Dishwasher 1022 €350.00)
6 ofthe formula Description | =VLOOKUP(B4,C2:7,2,0) 3148 Gloths 1239 e778
7 Retail Price =VLOOKUP(B4,C2:7,4,0} 3292 Strainer 1204 €12.75)