vlookup/hlookup alex kane. have you thought? lookup functions ? used to look up values to preform...
DESCRIPTION
Lookup Functions ? Used to Look up values To preform calculations Display resultsTRANSCRIPT
VLOOKUP/HLOOKUP
Alex Kane
Have you thought?
Lookup Functions ?
• Used to Look up values • To preform calculations• Display results
Lookup Tables
• Need a Lookup Table before inserting functions• Tables consist of AT LEAST • Two Rows• Two Columns
Composing Lookup Tables
• Arrange Data from Lowest value to Highest• Include only the lowest value in that range• (EX: instead of 90-100 for A, just use 90)• Breakpoint- lowest value in a range of numbers
What’s the difference?
• V-Vertical H-Horizontal
The Components
• 3 Key Factors to a Lookup Function• Lookup value• Table Array• Column/Row index number
• Possible Factors of a Lookup Function• Range Lookup
How to Compose a Vertical Lookup Function
• Cell = VLOOKUP (Lookup value, Table array 1:Table array 2,Column index number, [Range lookup])
• Example from Text: • F3 = VLOOKUP (E3,$A$3:$B$7,2)
Sample
How to Compose a Horizontal Lookup Function
• Cell = HLOOKUP (Lookup value, Table array 1:Table array 2, Row index number, [Range lookup])
• Example:• G4=HLOOKUP(G3,$B$4:$E$5,3,[True])
Sample
Now You Try!!!